--- In firebird-support@yahoogroups.com, "Gyowanny Queiroz"
<gyowanny@h...> wrote:

> Hi,
>
> Can I use "if" clause into a SQL property of IBX component (IBQuery

for example) ?

No, IF can be used in Stored Procedures only, but, again, not in SQL
statements within SP. Note you can Select From Stored_Procedure. Look
at FB1.5 Release Notes for CASE in Select too, but if your query is
"static" (you will not many times apply different WHERE conditions to
the same main query body) SP should be more effective.

Best regards,
Alexander.