Re: function returning boolean in a where caluse

>>>>> "Sunil" == Sunil <sunil_franklin_at_hotmail.com> writes:

 Sunil> Is it possible to do it? Thanks, Sunil.

If your talking about the PL/SQL BOOLEAN type, I don't htink so because SQL doesn't understand this type, unless this has changed with 9i.

However, you could return a type which SQL does understand e.g. return 0 and 1 for true and false etc.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!