Re: selecting all records where a column is null

Elmshauser, Erik wrote:

>Hi, I am trying to select every record from a table where a specific
>column does not have a value in it yet.  Is there a way to express that
>in a SQL statement?  Here are the few I tried:
>
>select * from table where field;
>select * from table where field = '';
>select * from table where field = NULL;
>
select * from table where field is null;

is rather than =.  Since null is undefined, it's not appropriate to test
for equality to null.

-Fran