Retrieving data when embedded single quote in data?

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