vani_r14 (9/23/2013)

---

Hi all

am trying to write a case statement an that currently returns one column. Is there any way that it could return multiple columns.

for e.g.

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.

Thanks

vani