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.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Mr. John
Sent: 4. desember 2009 12:15
To: firebird-support@yahoogroups.com
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.