The various UDF (User Defined Function) libraries offer many
attractive functions. Caution, not all UDF libraries are available
accross all platforms. I think the 'extract' function is native to IB6.

-------------------------------------------------------------

ericleung@... wrote:

>
> --- In IBObjects@y..., "Flipado" <arsoft@n...> wrote:
> > Hans:
> >
> > Thank you very much. I did a search using EXTRACT in this place and
> > got the answer. Why is not this function documented? I spend almost
> > one day looking for this!
> >
> > Artur Anjos
> >
> >
> > --- In IBObjects@y..., hans@h... wrote:
> > > I believe to remember something like extract(year of ...)
> > >
>
> Yes, you need to add your UDF library to IB.
> May be you could check with following page for some free UDF for IB
> (http://www.ibphoenix.com/ibp_contrib_download.html)
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/