The following example shows how to combine a CASE expression with a concatenation operator:
SELECT prodID, CASE prodSTATUS WHEN 1 THEN 'SENT' ELSE 'BACK ORDER' END || ' STATUS' FROM t1;
The following example shows how to combine a CASE expression with a concatenation operator:
SELECT prodID, CASE prodSTATUS WHEN 1 THEN 'SENT' ELSE 'BACK ORDER' END || ' STATUS' FROM t1;