Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieving data when embedded single quote in data?

Re: Retrieving data when embedded single quote in data?

From: Joseph S. Testa <jtesta_at_scioto.net>
Date: 1997/12/04
Message-ID: <348749B0.13FD8842@scioto.net>#1/1

Mark R. Aughenbaugh wrote:

> Is it possible to retrieve rows where there is a single quote (') as part of
> the data without the use of a function since the function would eliminate
> the use of an index?
>
> Ex. select name from tab1 where name like 'Al's %'

how about 'Al''s%'?? that works for inserts.

>
>
> This example, of course, won't work. Nor will escaping the quote.
>
> select name from tab1 where name like 'Al@'s %' escape '@'
>
>

Have not tried that one, sorry.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop
column script
ICQ UIN:  2832230(&oracle, home).
Received on Thu Dec 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US