Subject | CASE operations |
---|---|
Author | washito2 |
Post date | 2002-01-25T15:29:47Z |
Hi, I'm moving ( or trying to move) to IB / FB.
The next SELECT is SQL Standard, but doesn't work in IB
CASE
WHEN s.status > 25 THEN 'Fine'
....
ELSE 'xxx'
END
How can I write this operation in IB ?
Are there another SQL Standard operators / expressions not supported
in IB ?
Thanks
José
The next SELECT is SQL Standard, but doesn't work in IB
CASE
WHEN s.status > 25 THEN 'Fine'
....
ELSE 'xxx'
END
How can I write this operation in IB ?
Are there another SQL Standard operators / expressions not supported
in IB ?
Thanks
José