Re: selecting a NULL value?????

From: Gunjeet Singh <gunjeet_at_sunsparkle.corp.sun.com>
Date: 25 Aug 1998 00:31:44 GMT
Message-ID: <6rt0lg$q06$1@corpnews1.Corp.Sun.COM>

Try :

SELECT *
FROM this_table
WHERE (char_field = ''
OR char_field IS NULL)

^^^

NULL indicates the absence of a value.

Hope this helps.

Gunjeet

In article 44641140_at_news.concentric.net, lkolinek_at_concentric.net (larryk) writes:
> 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 Mon Aug 24 1998 - 19:31:44 CDT