Blank Recordset

[gio2888]

I guess this questions good in between with vbscript/asp and sql coding. I am trying to check for blank or null on a recordset... the select statment returned blank when I ran it against sql analyzer. Yet when I check it in my asp code, I tried
check = isNULL(rs1("title&quot) //check return neither true or false

I tried if rs1("title&quot = "" //that did not work either

Please Help, thanks! (I will post this in asp forum as well)

 

[TheBugSlayer]

Use IS NULL in SQL Server to check if the field is null.

 

[gio2888]

Thanks!