Re: Comparing NULL values
From: <RTProffitt_at_beckman.com>
Date: Mon, 14 Jun 1999 22:04:33 GMT
Message-ID: <7k3u9b$4vi$1_at_nnrp1.deja.com>
Date: Mon, 14 Jun 1999 22:04:33 GMT
Message-ID: <7k3u9b$4vi$1_at_nnrp1.deja.com>
[Quoted] Adding to Kenny's solution, of NVL,
select xxxxx
from xxxxx
where .....
and NVL(mycolumn, '~') IN ('a','b','c','d','~')....
I believe you had said you were using an IN clause.
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 15 1999 - 00:04:33 CEST