At 02:13 PM 17-08-00 +0000, you wrote:

>Hi All,
>
>I'm not sure if this is the correct place to post this so if it is
>not
>then I would appreciate it if I could be pointed to the correct place.
>
>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.
>
>TIA,
>
>Gerald S. Brown

IB doesn't natively support DATEPART. The fastest way to do it will be by
asking for a date range (if that's possible for what you need); otherwise,
check out the UDF (User-Defined Functions) libraries to see if the
functions you want are there. You need to declare the functions to your
database - check out DECLARE FUNCTION.

Helen
http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)