Re: Using function alias Column in Where clause

From: Sharkie <sharkie2_at_my-deja.com>
Date: Mon, 27 Mar 2000 19:01:50 GMT
Message-ID: <8bob6i$jno$1@nnrp1.deja.com>

Please remember that NULL is not comparable to 'empty' (nor any other values for that matter). If you suspect that what you compare against has null values, use NVL function on that field/value, then do your comparison (where clause). I'm not sure that is the reason in your case, but give it a try.

In article <38DF6BB4.333AA287_at_eunet.no>, hnyberg_at_eunet.no wrote:
> Select substr(DISPOSITION,InStr(DISPOSITION,'Fno',1)+4) as PosNo,
> ITEM_PS_DEF.DISPOSITION, ITEM_PS_DEF.POSITION From ITEM_PS_DEF
> where length(substr(DISPOSITION,InStr(DISPOSITION,'Fno',1)+4)) <>''
>
> I can't get this where part to function, it returns no records.
> If a skip the where clause, I see that many records has empty PosNo.
> If I use <>' ' instead of <>'', all records are returned.
> I have also tried: Is null/is not null, without any luck.
>
> Please help.
>
> --
> Regards Halvor
>
> A great Oracle tool:
> http://members.tripod.com/easydoc/dim.htm
>

--
If the human brain were so simple
that we could understand it,
we would be so simple we couldn't.
-Makes Sense... don't it?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 13:01:50 CST