Subject Problem with CASE.
Author João Luiz
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!

[Non-text portions of this message have been removed]