If you are using any version of Oralce prior to 8.16, then you must use Decode as others have mentioned.
In 8.16, Oracle added 'Select ... Case ...' to their syntax. It works faster then Decode and is more flexible too.
PF
>What is the replacement of IIF() in ORACLE.
>
>
>Thannks in advance.
(On an infant's shirt): Already smarter than Bush
