All Forums Analytics
NMadson-3173 44 posts Joined 09/06
17 Oct 2006
multiple results in CASE statement

Is it possible to return more than one result from a CASE statement?E.g.,CASE WHEN (condition-test1) THEN (true-result1), (true-result2) WHEN (condition-test2) THEN (true-result3), (true-result4) ELSE (false-result)ENDA comma as in my example above doesn't work, nor does an 'AND'.

Fred 1096 posts Joined 08/04
17 Oct 2006

No, the result of a CASE expression will be a single field.

You must sign in to leave a comment.