Re: selecting a NULL value?????

From: Malcolm Turner <mal_at_wcs.dnet.co.uk>
Date: Tue, 25 Aug 1998 13:51:52 GMT
Message-ID: <35e2ad79.74357203@news2.dnet.co.uk>

lkolinek_at_concentric.net (larryk) wrote:

>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?

---

The syntax for checking for a null is

      where char_field is null
Warning. Equating a field = '' may work at present (7.3) but is probably going to change.
Also check that char_field is declared as varchar2. If it's defined as char you may have to match spaces. Received on Tue Aug 25 1998 - 08:51:52 CDT