Does anyone know how can I use an equivalent to Oracle´s DECODE in
a
SELECT. For example

select decode(IN_TIPO_ACCION,'IR','1','0')as FIELD1 from ACCIONES

In pseudo code DECODE is like:

IF (IN_TIPO_ACTION = 'IR') THEN
'1'
ELSE
'0'
END IF


Thanks

Javier