Hi all

I would like to know if there is an equivalent to Immediate IF of VFP for
FireBird for eg.

SELECT IIF(Amt > 5, 1, 2) AS Flag

So flag will contain 1 if the amt col is greater than 5 else flag will
contain a 2

Please advise.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.806 / Virus Database: 548 - Release Date: 05/12/2004


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