>What is the replacement of IIF() in ORACLE.
>
>
>Thannks in advance.
DECODE() is like an IIF() function. Ex.
select decode(mytable.fieldname,'A','Aardvark','B','Bandicoot')
Fieldname - expression to search for
'A' and 'B' - possible values of Fieldname
'Aardvark' and 'Bandicoot' - values to return of corresponding possible value is correct
Check out the documentation for more info on DECODE().
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao