Subject Re: [firebird-support] Port MySQL to Firebird - SQL syntax - can I do this?
Author Helen Borrie
At 12:47 AM 11/07/2003 +0000, you wrote:
>Hi all,
>Presently I have an app with MySQL as backend and use a sql statement
>that has 'if's in them, does Firebird/Interbase support this?

No, but 1.5 has CASE and COALESCE which would possibly get you to a result
for Premium.

A much safer and more elegant way to handle this would be to write a
selectable stored procedure to calculate and output the whole set. This
would avoid placing the burden of this complicated specification in the SQL
string management that different applications would otherwise have to
manage independently each time it was wanted.