Re: Case-insensitive WHERE usage

Article View: borland.public.interbase.sql

Article #11001

Back to borland.public.interbase.sql Previous Next

#11001

From: Aage Johansen
Date: Sat, 21 Dec 2002 22:32

13 lines
1285 bytes

Edward Diener wrote:
> When using WHERE with a CHAR or VARCHAR field, is ther a way to specify that
> I want to match the value of the field with a string constant in a case
> insensitive manner ?


where Upper(THEFIELD) = Upper(:TheValue)

or, you might try a case insensitive collation.


Regards,
Aage J.

Technical Details

Message-ID: <3E04EBF2.1EE39FD6@offline.no>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e04e5fe$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,5eb36440605f994f
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-21 14:38:55 PST
Message-ID: <3E04EBF2.1EE39FD6@offline.no>
Date: Sat, 21 Dec 2002 23:32:18 +0100
From: Aage Johansen <aagjohan@offline.no>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Case-insensitive WHERE usage
References: <3e04e5fe$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.212.34.185
X-Trace: newsgroups.borland.com 1040509951 80.212.34.185 (21 Dec 2002 14:32:31 -0800)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message