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