WHEN [conditional test 1] THEN [result1]
WHEN [conditional test 2] THEN [result2]
ELSE [defaultresult]
END
SELECTCASE5WHEN1THEN"this is a"WHEN2THEN"this is b"WHEN3THEN"this is c"WHEN4THEN"this is d"ELSE"error"ENDerrorSELECTCASE1WHEN1THEN"this is a"WHEN2THEN"this is b"WHEN3THEN"this is c"WHEN4THEN"this is d"ELSE"error"END
this is a