| Subject | Re: [firebird-support] Equivalent of VFP IIF() in FireBird SQL |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-12-06T07:49:32Z |
At 01:00 PM 6/12/2004 +0530, you wrote:
./hb
>Hi allUse a CASE expression - syntax is in the v.1.5 release notes.
>
>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.
./hb