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.7038619.3001176/
D=groups/S=1705115386:HM/EXP=1108080184/A=2532114/R=2/SIG=12k3v05na/*htt
p://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=110799378
4323661>

<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/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=Unsubscribe

>

* 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]