Im using SQL server at the backend, and in one of the tables I hv a smalldatetime datatype field- TrainingStartDate.

Many records in the db have this field set to Null

Now, to avoid other problems If I want to check it for NULL values ,I'm unable to do so. Iv tried the following but all conditions return FALSE.

if rs("TrainingStartDate") = Null

if rs("TrainingStartDate") = "Null"

if rs("TrainingStartDate") = vbNull