Re: selecting a NULL value?????

Replace char_field = null with char_field is null

Regards,

    Nenad Noveljic
    noveljic_at_usa.net

larryk wrote in message <35e1efca.44641140_at_news.concentric.net>...
>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 - 08:11:38 CDT