Subject conditional where clause
Author Cornel Rebegea
Hi, I have one question to I couldn`t find the answer despite my
searching.
How can you make a conditional where clause in Firebird ?
I will give you an example of what I am used to do in Foxpro:

Select *
from Table
where iif(:pcond, Table.field = :par1, True)

that is, if param pcond is true than inforce condition Table.field =
:par1, else no filter.