Re: Include Null values in SELECT output

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:pPAtb.10448$P%1.9207659_at_newssvr28.news.prodigy.com...
> Is there any sort of simple setting to cause Oracle 8.1.7 to include Null
> values in a <> Where clause?
>
> SELECT .... FROM ....
> WHERE Status <> 'Completed';
>
> In this particular case, Status is set to permit Null values and I would
> like the query to return ALL records that don't have "Completed" for the
> Status, including any that are Null.
>
> Note: I've updated the application to put a default Status in the field,
but
> there are still many legacy records with no Status, and a number of other
> Fields with the same situation.
>
>

SELECT .... FROM ....
WHERE nvl(Status,"Blank") <> 'Completed';

This will "replace" or substitute the null value with a string "Blank".

• \|/ Onismus o o __________________________________oOO_(_)_OOo______________________________ E-Business and Information Management | Tel: +27 11 350 3414 Knowledge Discovery & Dissemination | Fax: +27 11 350 8585 onismusr-AT-absa-DOT-co-DOT-za | Cel: +27 83 591 5310

  ---