Re: case sensitive

From: Jacques Raymond Kilchoer <jrkilch_at_costcare.com>
Date: 1997/07/03
Message-ID: <33BC0F08.42507826@costcare.com>#1/1

--------------CA49BD1D64A1992417D5B41F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David BARATTE wrote:

> Hi,
>
> Is there a function in SQL which doesn't care of the case
> of a string when you use a SELECT statement.
>
> e.g: with a record containing the string TOTO
> i want to retrieve it with
>
> select * from table_name where field_name='toto'
>
> Thanks in advance.
>
> mailto:david.baratte_at_uhb.fr

select * from table_name where lower (table_name) = 'toto' ; select * from table_name where upper (table_name) = 'TOTO' ;

of course that means you won't be using any index on table_name for the query :(

--
 ___                                                               ___
(___)=============================================================(___)
|   | Jacques Raymond Kilchoer           MIS:Applications Support |   |
|   | Assistant DBA               /^\  ^     (714) 729-4500 x3733 |   |
|   | Cost Care, Inc.       /\  _/   \/ \            fax 729-4651 |   |
|   | Newport Beach   /\ /\/  \//     \  \_/\                     |   |
|   | CA 92660       /  \ /    /       \ /   \   Suisse/Schweizer |   |
|___|           ____/____\____/_________\___ _\_______   Svizzero |___|
(___)=============================================================(___)


--------------CA49BD1D64A1992417D5B41F
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
David BARATTE wrote:
<BLOCKQUOTE TYPE=CITE>Hi,

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is there a function in SQL
which doesn't care of the case
<BR>of a string when you use a SELECT statement.

<P>e.g: with a record containing the string TOTO
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i want to retrieve it with

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
select * from table_name where field_name='toto'

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Thanks in advance.

<P><A HREF="mailto:david.baratte_at_uhb.fr">mailto:david.baratte_at_uhb.fr</A></BLOCKQUOTE>
&nbsp; select * from table_name where lower (table_name) = 'toto' ;
<BR>select * from table_name where upper (table_name) = 'TOTO' ;

<P>of course that means you won't be using any index on table_name for
the query :(

<P>--
<BR><TT>&nbsp;___&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
___</TT>
<BR><TT>(___)=============================================================(___)</TT>
<BR><TT>|&nbsp;&nbsp; | Jacques Raymond Kilchoer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
MIS:Applications Support |&nbsp;&nbsp; |</TT>
<BR><TT>|&nbsp;&nbsp; | Assistant DBA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
/^\&nbsp; ^&nbsp;&nbsp;&nbsp;&nbsp; (714) 729-4500 x3733 |&nbsp;&nbsp;
|</TT>
<BR><TT>|&nbsp;&nbsp; | Cost Care, Inc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
/\&nbsp; _/&nbsp;&nbsp; \/ \&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
fax 729-4651 |&nbsp;&nbsp; |</TT>
<BR><TT>|&nbsp;&nbsp; | Newport Beach&nbsp;&nbsp; /\ /\/&nbsp; \//&nbsp;&nbsp;&nbsp;&nbsp;
\&nbsp; \_/\&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp; |</TT>
<BR><TT>|&nbsp;&nbsp; | CA 92660&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&nbsp;
\ /&nbsp;&nbsp;&nbsp; /&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ /&nbsp;&nbsp;
\&nbsp;&nbsp; Suisse/Schweizer |&nbsp;&nbsp; |</TT>
<BR><TT>|___|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
____/____\____/_________\___ _\_______&nbsp;&nbsp; Svizzero |___|</TT>
<BR><TT>(___)=============================================================(___)</TT>
<BR>&nbsp;</HTML>

--------------CA49BD1D64A1992417D5B41F--

Received on Thu Jul 03 1997 - 00:00:00 CDT