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