Re: Retrieving data when embedded single quote in data?

Sorry! Brain cramp.
select name from tab1 where name like 'Al''s %' (using two single quotes together)

works great!

Mark R. Aughenbaugh wrote in message <34873129.0_at_news3.uswest.net>...
>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 %'
>
>This example, of course, won't work. Nor will escaping the quote.
>
>select name from tab1 where name like 'Al@'s %' escape '@'
>
>Any help would be appreciated.
>marka_at_erudite.com
>
>
>
Received on Thu Dec 04 1997 - 00:00:00 CST