multiple results in CASE statement

Analytics
Enthusiast

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)
END

A comma as in my example above doesn't work, nor does an 'AND'.
1 REPLY
Teradata Employee

Re: multiple results in CASE statement

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