am trying to write a case statement an that currently returns one column. Is there any way that it could return multiple columns.
case when <condition> then (Select substring(column, 1, 3)) as Col1, (Select substring(column, 4, 2)) as Col2
else '' end
Can some one please help. It feels like it's not possible unless I write multiple case statements, but just wanted to check.