Using function alias Column in Where clause

From: Halvor Nyberg <hnyberg_at_eunet.no>
Date: Mon, 27 Mar 2000 16:09:56 +0200
Message-ID: <38DF6BB4.333AA287@eunet.no>

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 Received on Mon Mar 27 2000 - 08:09:56 CST