Re: selecting a NULL value?????

try to use " where char_field is null "

larryk wrote:

> Hello...
>
> Here is a select statement:
>
> SELECT *
> FROM this_table
> WHERE (char_field = ''
> OR char_field = null )
>
> this_table.char_field contains nothing. Why does this SQL statement
> not work?
>
> thanks in advance
> larry
Received on Wed Aug 26 1998 - 00:00:00 CDT