> -----Original Message-----
> From: gerbreown@... [mailto:gerbreown@...]
> Sent: Jueves 17 de Agosto de 2000 10:13
>
> My question is: How do I select records in an IB table where the
> month and year of a date field = 8 and 2000 respectivaly.
>
> I have tried MONTH(field), DATEPART("m", field), EXTRACT MONTH FROM
> field and none of these functions work in IB.

I posted something about basic functions in IB-Conversions when dealing with
general conversion from IB to MsSql. In IB6, you need
where extract(month from field)=8
and extract(year from field)=2000

Extract() is available in IB6 in every dialect.

C.