Re: Select a row with hull column

From: Dante <dnotari_at_my-dejanews.com>
Date: Fri, 07 May 1999 21:51:09 GMT
Message-ID: <7gvn8b$28o$1@nnrp1.deja.com>

Something = NULL is always FALSE

If you want to use NULL you have to use logout_time IS NULL

logout_time IS NOT NULL

Regards
Dante

In article <373349CF.8C68A55C_at_detroitedison.com>, lechkung <"lechkung<<remove>>"@detroitedison.com> wrote:
> I'm trying to select the rows in a table that has a NULL in the column
>
> select * from set_user where logout_time = NULL;
>
> This isn't working. Can someone get me know how to do it?
>
> lechkungNOSPAM_at_detroitedison.com
> remove "NOSPAM" to reply
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 16:51:09 CDT