I am trying to write a simple query to return all rows with a certain 'Null' value.  The select statement works but not the where statement.  The query is the following:

Select * from tblCsEventReminders
where CompletedDate = NULL

The where statement returns no data without errors even though I see 'Null' in the column. I included properties of the column. I am not sure if that will help.

Select * from tblCsEventReminders
where CompletedDate = NULL

To check for NULL, use "IS NULL" rather than "= NULL".  Otherwise, the result is unknown rather than the expected true or false.

SELECT *
FROM dbo.tblCsEventReminders
WHERE CompletedDate IS NULL;

hi Kurt,

think I have figured it - you need to do this instead:

where CompletedDate is NULL

cheers

dan

Thank you!