Its funny that you mention that. I am only aware of UPPER(). However, I do
know that the UDF functions bundled with Firebird 1.5 contains LOWER() which
gets a CSTRING(255) passed to it. Hope that helps.

-----Original Message-----
From: Martin Catherall [mailto:mc@...]
Sent: Wednesday, February 09, 2005 3:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] convert field to lower/upper case in where
clause



Hi,

I wish to look for a particular word in the where clause of my query, I
do not want to do a case sensitive match,
so I figured if I just converted the two fileds to lower case then I
could do the match with some degree of accuracy.

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'

can anybody please help with this seemingly simple question.

many thanks in advance.

martin.



Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"

W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>

Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>

-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Thursday, 10 February 2005 12:34 p.m.
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Scalability principles: Can
someone confirm



There are interesting things in this thread. Maybe Helen - in
her slow
hours(!) - could revisit the "Some Solutions to Old Problems"
document and
add to it...


--
Aage J.



Yahoo! Groups Sponsor
ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=1290l1c4a/M=298184.6018725.7038619.3001176/
D=groups/S=1705115386:HM/EXP=1108078571/A=2532114/R=2/SIG=12kqro73u/*htt
p://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=110799217
1228500>

<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2532114/rand=592249424>


_____

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]




Yahoo! Groups Links