DECODE
DECODE(
expr
,
value
,
result
[,
value
,
result
]...,
default
)
Compares
expr
with each value and returns either the first matching value's result or the default value if no values match.
Parent topic:
AcuXDBC Functions