5replies
-
decode(CODE,'101','A','102','B','103','C','204','D','206','A','203','A','208','B','24','X',Code)
How to achieve this in MV
datatype of Code is - long
We have implemented as below but getting error . - Amit KothariEmployee
CASE
WHEN (
CAST(CODE AS text) = '101'
) THEN 'A'
WHEN (
CAST(CODE AS text) = '102'
) THEN 'B'
WHEN (
CAST(CODE AS text) = '103'
) THEN 'C'
WHEN (
CAST(CODE AS text) = '204'
) THEN 'D'
WHEN (
CAST(CODE AS text) = '206'
) THEN 'A'
WHEN (
CAST(CODE AS text) = '203'
) THEN 'A'
WHEN (
CAST(CODE AS text) = '208'
) THEN 'B'
WHEN (
CAST(CODE AS text) = '24'
) THEN 'X'
ELSE CAST(CODE AS text)
END
Reply