Heh, I have NEVER been able to successfully declare one for some reason.
Firebird comes with 2 UDF libraries. They both have .SQL scripts. I just
load up the scripts and run them and it installs all the UDF functions into
my databases.

-----Original Message-----
From: Nigel Weeks [mailto:nweeks@...]
Sent: Wednesday, February 09, 2005 4:29 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] convert field to lower/upper case in
where clause



The best answer I can give is that it's in the docs - it's been years since
I've declared one.

Roughly, from memory, it's something like:
DECLARE EXTERNAL FUNCTION lower
cstring(2000)
returns cstring(2000) free_it
entry_point "IB_UDF_lower' MODULE_NAME 'ib_udf';

Have a look in the PDF's that came with Firebird, and on the Firebird site.
No doubt knowledgeable people in this list will correct my
recollection...;-)

Nige

> -----Original Message-----
> From: Martin Catherall [mailto:mc@...]
> Sent: Thursday, 10 February 2005 11:10 AM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] convert field to lower/upper case in
> where clause
>
>
>
> Hi Nigel,
>
> I am using firebird 1.03, the lower and upper function do not
> work when
> i do the following query in IBEXPERT
>
> select * from tblTest where lower(tblTest.first_name) = 'james';
>
> I get
> An error was found in the application program input parameters for the
> SQL statement.
> Dynamic SQL Error.
> SQL error code = -804.
> Function unknown.
> LOWER.
>
> (note that the lower function I used was lower case, however I also
> tried upper case)
>
> please could you tell me how to decalare the external functions (do I
> have to do this in firebird)????
>
> cheers
>
> martin.
>
>
> -----Original Message-----
> From: Nigel Weeks [mailto:nweeks@...]
> Sent: Thursday, 10 February 2005 1:03 p.m.
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] convert field to lower/upper case in
> where clause
>
>
>
>
> > trouble is I'm not sure how to convert a field to lower case.
> > to get the gist of what I am trying to acheive I have
> > included the where
> > clause below -- which does not work.
> >
> > select * from tblTest
> > where LCASE(tblTest.first_name) = 'james'
> >
>
> You've almost got it!
>
> select * from tblTest where lower(tblTest.first_name) = 'james';
>
> Nige.
>
> ps. I think the lower() and upper() are (still) UDF's, so
> remember to
> declare the external functions if they don't work. I could be
> wrong on
> this...!!!
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
> <http://us.ard.yahoo.com/SIG=129pms1of/M=298184.6018725.703861
> 9.3001176/
> D=groups/S=1705115386:HM/EXP=1108080184/A=2532114/R=2/SIG=12k3
> v05na/*htt
> p://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time
> =110799378
> 4323661>
>
> <http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.30011
> 76/D=group
> s/S=:HM/A=2532114/rand=100835280>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=U

nsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .



=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc
Cube Server


[Non-text portions of this message have been removed]




Yahoo! Groups Links









__________ NOD32 1.994 (20050209) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com



[Non-text portions of this message have been removed]




Yahoo! Groups Links