Helen,

Thanks for the quick response. I tried BETWEEN and that worked so I
will just have to specify the FIRST and LAST day of the month and use
in my WHERE clause.

As for your next response, the firewall at my company does not allow
me to go to any other newsgroups(ie. MERS) except this one.

Gerald S. Brown

--- In IBDI@egroups.com, Helen Borrie <helebor@w...> wrote:
> 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.)