Re: (Q): SQL-Queries

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

Article #156

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

#156

From: Rafael Guimaraes
Date: Mon, 27 Oct 1997 00:00

18 lines
1373 bytes

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


Well, I think that a good way is to use the UPPER command:

  SELECT titel FROM database WHERE UPPER(titel) LIKE '%APPLE%'

                                  []s Rafael Guimaraes

Technical Details

Message-ID: <6334ei$i4r@srv4-poa.nutecnet.com.br>

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

References: <344B1EAD.E25@fbch.tuwien.ac.at> <344B6B9D.7851F65@ic2c.com> <01bcdeb0$d6b863b0$0101a8c0@ntsql>

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: "Rafael Guimaraes" <rguima@redegazeta.com.br>
Subject: Re: (Q): SQL-Queries
Date: 1997/10/27
Message-ID: <6334ei$i4r@srv4-poa.nutecnet.com.br>
X-Deja-AN: 285386781
References: <344B1EAD.E25@fbch.tuwien.ac.at> <344B6B9D.7851F65@ic2c.com> <01bcdeb0$d6b863b0$0101a8c0@ntsql>
X-MimeOle: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: NutecNet
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers,microsoft.public.sqlserver.programming

Reply to Parent Message