I need to return more than 1 field on each WHEN and also assign an ALIAS.
You can only produce a single value of a specific data type from the output of a case expression. To do what you desire, create a custom composite type and return that. You get to name the fields when you define the composite type.
