🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #213

Re: case insensitive

#213
From: Blair Kenneth Adamache
Date: Tue, 25 Feb 2003 19:05
10 lines
1650 bytes
Have a look at this article:


http://www7b.boulder.ibm.com/dmdd/library/techarticle/0203adamache/0203adamache.html

exist_world_beyond_yours wrote:

> "abc is alpha" is different from "ABC Is aLpHA" in DB2. How to make "LIKE
> xxxx" match both?
> thank you for reviewing
Technical Details
Message-ID: <3E5BBE72.BEB7074C@yahootoomuchspam.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!nntp.cs.ubc.ca!nntp-relay.ihug.net!ihug.co.nz!uunet!lax.uu.net!dfw.uu.net!an02.austin.ibm.com!ausnews.austin.ibm.com!hanover.torolab.ibm.com!not-for-mail
References: <3e5bad9e_1@news.tm.net.my>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5d71,3b0023afd074a7db
X-Google-Attributes: gidf5d71,public
X-Google-Thread: f6611,3b0023afd074a7db
X-Google-Attributes: gidf6611,public
X-Google-Thread: 10f47b,3b0023afd074a7db
X-Google-Attributes: gid10f47b,public
X-Google-ArrivalTime: 2003-02-25 11:35:12 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!nntp.cs.ubc.ca!nntp-relay.ihug.net!ihug.co.nz!uunet!lax.uu.net!dfw.uu.net!an02.austin.ibm.com!ausnews.austin.ibm.com!hanover.torolab.ibm.com!not-for-mail
From: Blair Kenneth Adamache <badamache@yahootoomuchspam.com>
Newsgroups: bit.databases.mssql-l,comp.databases.ibm-db2,comp.lang.java
Subject: Re: case insensitive
Date: Tue, 25 Feb 2003 14:05:22 -0500
Organization: IBM Toronto Lab -- Workstation Database
Lines: 11
Message-ID: <3E5BBE72.BEB7074C@yahootoomuchspam.com>
References: <3e5bad9e_1@news.tm.net.my>
Reply-To: badamache@yahoonomorespam.com
NNTP-Posting-Host: granite3.torolab.ibm.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: hanover.torolab.ibm.com 1046199866 21510 9.26.185.190 (25 Feb 2003 19:04:26 GMT)
X-Complaints-To: usenet@hanover.torolab.ibm.com
NNTP-Posting-Date: Tue, 25 Feb 2003 19:04:26 +0000 (UTC)
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en