Hi dude.

I'm using Firebird 2.1.3.


From: Alan McDonald
Sent: Wednesday, August 18, 2010 2:49 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Problem with CASE.

> 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





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