You can do uppercase with UPPER.

select *
from tblTest
where UPPER(tblTest.first_name) = 'JAMES'

Also, "containing" keyword is not case sensitive if you don't
necessarily need equality check.

Adam



--- In firebird-support@yahoogroups.com, "Martin Catherall" <mc@w...>
wrote:

> 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@w... <mailto:tmc@w...>
>
> -----Original Message-----
> From: Aage Johansen [mailto:aagjohan@o...]
> 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.300117
6/

>

D=groups/S=1705115386:HM/EXP=1108078571/A=2532114/R=2/SIG=12kqro73u/*h
tt

>

p://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1107992
17

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