Lower is a UDF that's supplied with Firebird, but you have to use the
'declare external function' step to hook it in.

The 'upper' one, however, is built in, is guaranteed to be available on
every Firebird install, and really, do you NEED lower?
Why not do everything with 'upper'?

Nige.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Hans
> Sent: Friday, 3 June 2005 10:01 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] LOWER
>
> it seems that
>
> a,b varchar(40);
> a = lower(b);
>
> works
>
> ----- Original Message -----
> From: "Fr. Robert Bower" <robertb@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, June 02, 2005 3:35 PM
> Subject: [firebird-support] LOWER
>
>
> >I would like to do a lower function. It appears that firebird does
> > not support it. Is there an easy way to acomplish the task?
> >
> > Thanks
> >
> > Fr. Robert
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net 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
> >
> >
> >
> >
> >
> >
> >
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>
> __________ NOD32 1.1124 (20050602) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>