Subject | RE: [ib-support] CASE WHEN possible in select query? |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2002-08-19T18:06:42Z |
Hi
Not in Interbase but it will be in Firebird 1.5
Groete
Gerhardus
Not in Interbase but it will be in Firebird 1.5
Groete
Gerhardus
>
> Hi
>
> Is this possible in Interbase:
>
> SELECT ARTIKELID, MP = CASE MULTIPACK WHEN 'Y' THEN 'YES' ELSE 'NO'
> END
> FROM ARTIKELEN