Testing for Null in SQL Database Field

[cajsoft]

Hello Gurus,
I'm trying to test for a null or no data in a field from
an MS SQL table.

e.g I have 3 fields (Emp_Id,Emp_Name,Emp_Dob)
I need to check if the Emp_Dob (Date field) has been entered.

I thought just doing something like this would be enough:

cn.Connect = "uid=sa;pwd=;server=" & txtsvr & ";driver={SQL Server};database=" & txtdb & ";"
cn.CursorDriver = rdUseIfNeeded
cn.EstablishConnection rdDriverNoPrompt
cn.GetData  <- Executes the SQL statement
   
   Set RS = cnclearjob.LastQueryResults
      Do Until RS.EOF
         If RS("Emp_Dob") = Null Then
               Check1.Value = 1
               MsgBox ("DOB Empty!")
         End If
         RS.Movenext
      Loop

Unfortunately, VB doesnt recoginise that the empty value in the field, so ignores the 'IF' statement, even if I change the statement to (IF RS("Emp_Dob")= "" then ...... that doesnt work either!

Anyone shed some light on this!!!??

Cheers
Craig.

[Stevie]

Try

If IsNull(RS!Emp_Dob)

[cajsoft]

Hey, Thanks a lot.... that did the trick!!

Thanks Again.