RE: SQL 'Case When...'

> Don't know if it's possible, but how do I make the following SQL
> statments right?
>
> select attribute[1]
> from table
> case when attribute[1]='yes'
> then select attribute[2] from table
> else select attribute[3] from table;
>
> Basically, I want to compare attr[1], if true then select some fields
> from table; if false then select others.

Try this:

select case attribute[1]
when 'yes' then attribute[2]
else attribute[3]
end
from table;

--
Oliver Graf
Triestram & Partner GmbH
Kohlenstr. 55, 44795 Bochum, Germany
Phone +49 234 94375-15
Fax +49 234 452206
eMail: O(dot)Graf(at)t-p(dot)com
http://www.t-p.com