Re: (Q): SQL-Queries

Article View: comp.lang.pascal.delphi.databases

Article #154

Back to comp.lang.pascal.delphi.databases Previous Next

#154

From: Sid/
Date: Fri, 31 Oct 1997 00:00

33 lines
2063 bytes

I'd be very carefull about the following if I were you...

If you are thinking about the changing the sort order, lookout the 
procedure in SQL books on line first.

It's harder than it looks!

Sid/


In article <01bce513$bef703d0$1e00000a@potest>, ryancrawcour@hotmail.com 
says...
> If you don't want to use the upper command each and every time then perhaps
> you could change the default sort order on your SQL server - this is done
> thorugh the SQL setup icon ... chage it to something like - "case
> insensitive" Then searching for apple will return all possible case
> combinations eg. Apple, APPLE, ApPlE etc.
> 
> Rafael Guimaraes <rguima@redegazeta.com.br> wrote in article
> <6334ei$i4r@srv4-poa.nutecnet.com.br>...
> > >Benoit Chailler <benoit@ic2c.com> wrote in article
> > ><344B6B9D.7851F65@ic2c.com>...
> > >>
> > >> Heinz A. Krebs Dipl.-Ing. wrote:
> > >> > servas!
> > >> > i have three small questions about sql-queries:
> > >> > 1. how can i make a case-insensitive selection? if i make the
> > >following:
> > >> >      SELECT titel FROM database WHERE titel LIKE '%apple%'
> > >> >    i don't get the entries with 'Apple', but i want them all!
> > 
[snip]

Technical Details

Message-ID: <MPG.ec3f844391860b4989681@news.idiscover.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<344B1EAD.E25@fbch.tuwien.ac.at> <344B6B9D.7851F65@ic2c.com> <01bcdeb0$d6b863b0$0101a8c0@ntsql> <6334ei$i4r@srv4-poa.nutecnet.com.br> <01bce513$bef703d0$1e00000a@potest>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,c6b02df51994e2b0
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,c6b02df51994e2b0
X-Google-Attributes: gid10de66,public
X-Google-Thread: 11301e,c6b02df51994e2b0
X-Google-Attributes: gid11301e,public
From: sid@tisl.co.uk (Sid/)
Subject: Re: (Q): SQL-Queries
Date: 1997/10/31
Message-ID: <MPG.ec3f844391860b4989681@news.idiscover.co.uk>
X-Deja-AN: 286185933
References: <344B1EAD.E25@fbch.tuwien.ac.at> <344B6B9D.7851F65@ic2c.com> <01bcdeb0$d6b863b0$0101a8c0@ntsql> <6334ei$i4r@srv4-poa.nutecnet.com.br> <01bce513$bef703d0$1e00000a@potest>
X-NNTP-Posting-Host: 194.128.134.253
Organization: Internet Discovery Customer News Service
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers,microsoft.public.sqlserver.programming

Reply to Parent Message