> 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.Graf@t-p.com
http://www.t-p.com