WHERE Clause concerning NULL, and datetime field

[Wyldcard9]

The guy who designed our Microsoft SQL Server Databases, allowed datetime fields to be nulls. I ran across a record that had a null in it, and tried to create a query to determine how many records are like this.

SELECT *
FROM .[EP3_14]
WHERE ID_1015=NULL

This returns no rows at all.

I modified the code to see if I could return any rows on that datetime field, and tried this:

SELECT *
FROM .[EP3_14]
WHERE ID_1015<'2004-01-01 00:00:00.000'

This returns all records with a datetime stamp, that is below that datetime stamp. The NULL record is not displayed.

What do I need to do in order to return rows with only NULL value?

Thanks in advance.

 

[mwolf00]

SELECT *
FROM .[EP3_14]
WHERE ID_1015 IS NULL

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[Wyldcard9]

mwolf00,

Thanks a lot. That worked great.