Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieving data when embedded single quote in data?
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