> Hi all!
> It's my first message in the list.
>
> I'm trying to execute this query on Firebird:
>
> select id, case id when 70 then 'oi' end as caso from movimentacao;
>
> And it returns an SQL error (-104) on the 'when' command.
>
> I also tried:
>
> select id, case when id=70 then 'oi' end as caso from movimentacao;
>
> And got the same error.
>
> Thx!
>

do you have the correct version of Firebird which understands CASE?
Alan