which could be

where coalesce(contact_date, injury_date) between...

Thierry

Anderson Farias a écrit :

> Hi, try this:
>
>
> where IIF(CONTACT_DATE is not null, CONTACT_DATE, INJURY_DATE)
> between :startdate and :enddate and ...
>
>
> Regards,
> Anderson
>
>
> ----- Original Message -----
> From: "william_yuwei" <william_yuwei@...>
>
>
> Hi, All
>
> I tried to put like this into where clause, and it failed:
>
> where IIF(CONTACT_DATE is not null, CONTACT_DATE between :startdate
> and :enddate, INJURY_DATE between :startdate and :enddate) and ...
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>