Subject RE: [firebird-support] Switch statement in FIREBIRD
Author Svein Erling Tysvær
Can you show an example (imagined Firebird syntax) of what you're searching for and tell which Firebird version you're using? I generally find that CASE and sometimes COALESCE or UNION fit my needs, but that might not be suitable in your case.


-----Original Message-----
From: [] On Behalf Of Mr. John
Sent: 4. desember 2009 12:15
Subject: [firebird-support] Switch statement in FIREBIRD

Hi ! I'm looking for a solution to handle multiple if-else statements switch in firebird just like DO CASE in FOXPRO,SELECT CASE in VB, SWICH in C++.
I found CASE but seems to apply only for an expression.Thanks for any clue.