Hi there. I'm using ASP and SQL to extract values from a database. I defined the variables, then I'm using them in my query. So far so good. What I want to do is limit my query results to only display values when the Assignee field in the database contains data. I can't figure out how to code for a null value. Assignee is a variable I've defined - the data is extracted from a form, like all the other fields in the query. I've tried using "...where Assignee <> ""...", etc. and nothing's working. Please help!!!<BR><BR>Here's my code:<BR><BR>If CallDesc = yes Then <BR>SQLtemp = "SELECT * FROM Log where Assignee <> "" AND (ID='"& vID &"' AND Date='"& DtOpen &"') "<BR>End If <BR><BR>Thanks so much for any help you can give me.