Hi

whats the access equivelant of the
PL/SQL "decode" statement.

Thanks
Mustafi

Could you describe what the PL/SQL "decode" statement does?

Thanks,

Simon

If you're asking about the decode function that I'm thinking of, the immediate if function will work:
iif(expression,true part, false part)

It's not exactly like decode but you can get the same results.

For instance:
select iif(1=2,"It's true","It's false") as example
from dual;

would result in
example
-------
It's false

Just like decodes, you can nest iif() functions.