Hello Loukas,
You do not mention what the actual problem is and why you need a work-around. In ORACLE the if then else can very effectively be substituted by the DECODE function:
DECODE(expr,value1[,return1,value2,return2.....,]default)
Is this the kind of function you are searching for? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com