Subject Re: [firebird-support] need help on query
Author Edwin Pratomo
On Monday 30 June 2003 10:56, Regina Phandu wrote:
> 2. Is firebird support SELECT CASE? Does anyone have any idea how to
> convert a view that are using SELECT CASE to firebird? Can I do it in
> Firebird or I have to make it a store procedure instead of view?

CASE expression is supported in Fb 1.5.
Some uses of CASE are to flatten queries containing some kind of sub-queries,
so I think your CASE query can be rewritten using subquery instead.