>I am using embedded SQL statements in Visual Basic 6 to query data from a DB2 database. The field I am trying to check and see if it's value is Null is Cancel_date, it is a date/time field.
>I don't know how to write the Select statement so that it checks if it's value is Null. I tried:
>
>SELECT * FROM TableName WHERE CANC_DT = NULL
>SELECT * FROM TableName WHERE CANC_DT = 'NULL'
>SELECT * FROM TableName WHERE CANC_DT = ""
>
>none of these work, does anyone know how to do this?
>thanks,
>Ryan Uhl

Normally, you use the IS operator:

SELECT * FROM TableName WHERE CANC_DT IS NULL