--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > 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.
>
> What type is pcond ? If it contains 0/1 for true/false, then use
>
> where :pcond=0 or Table.field = :par1
>
> Ivan
>

Thanks, a no brainer after all, and sorry for not being on the spot
with you (I `ve forgotten all about it).

Cornel Rebegea.