Re: Comparing NULL values
From: Jan-Marcel <jan-marcel_at_wau.mis.ah.nl>
Date: Tue, 15 Jun 1999 06:58:13 GMT
Message-ID: <FDCwp2.4oM_at_ahisinfr.xs4all.nl>
Date: Tue, 15 Jun 1999 06:58:13 GMT
Message-ID: <FDCwp2.4oM_at_ahisinfr.xs4all.nl>
RTProffitt_at_beckman.com heeft geschreven in bericht
<7k3u9b$4vi$1_at_nnrp1.deja.com>...
>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
>
But be aware that using the NVL function (as all functions and operations
do) spoils the use of indexes on your column!
Good luck,
Jan-Marcel Received on Tue Jun 15 1999 - 08:58:13 CEST