Re: Selecting non NULL values

The actual select statement I am using is:

select * from data where TODAYS_TIME like '%12%' && POSTINGS is not NULL;

Postings is column 4 and TODAYS_TIME is column 2.

Sorry about the bad data.
Ryan

"Ryn" <mattycruft_NO_at__SPAM_daemons.net> wrote in message news:AfJp8.40521$1f1.3189806_at_e3500-atl2.usenetserver.com...
> Hello folks,
>
> I am trying to figure out why:
>
> select * from data where TODAYS_TIME like '%12%' && TODAYS_TIME is not
 NULL;
>
> does not work. I still get:
>
> 2002-03-19 12:00:01 Atlanta 786
> 2002-03-20 12:00:00 Atlanta 777
> 2002-03-21 12:00:00 Atlanta
> 2002-03-22 12:00:00 Atlanta
> 2002-03-23 12:00:00 Atlanta 783
> 2002-03-30 12:00:00 Atlanta 745
> 2002-03-31 12:00:01 Atlanta 736
>
> The last column in each line has an occasional NULL value.
>
> Thanks for any info,
> Ryn
>
>
>
Received on Sun Mar 31 2002 - 21:21:13 CEST