Home -> Usenet -> comp.databases.oracle -> Selecting non NULL values

Selecting non NULL values

From: Ryn <mattycruft_NO_at__SPAM_daemons.net>
Date: Sun, 31 Mar 2002 14:18:31 -0500
Message-ID: <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:18:31 CEST












Original text of this message