Re : Multiple values resut of CASE statement
591793Jan 29 2009 — edited Jan 29 2009Hello All,
Hope all is well. I was trying to basically return multiple values if a certain value 'X' was passed. for example,
select
case T1.C1
when 'X' then ('XX','YY')
else T1.C1
end
from T1
but I am getting error. I am unable to figure out as to how do you get multiple values out of a single value in SQL. I will then be passing this multiple values as filter in where clause. For example,
where ('XX','YY') in T2.C1
Thanks in advance and let me know if I have missed on something.
- Sam