Re: SQL 'ESCAPE' Problem

To specify embedded quotation marks in a search string, precede the quotation mark with another one e.g.

select loc_description
where loc_description like 'Joe''s%'
/

to search for the string: Joe's%

Hope this solves the problem, regards         

• Martyn Cavett Senior ORACLE Analyst LGT Asset Management London, UK. home: cavett_at_globalnet.co.uk work: Martyn.Cavett_at_gtplc.com

These views are my own and not those of my employer. Normal conditions apply.
nb. anonymous return address used - please replace reply address with those given above.

Andre Allen <NoSpam_at_interaccess.com> wrote in article <5p47ir$2ak_002_at_news.interaccess.com>...
> Hello Everyone
>
> I am having trouble with the following SQL Statement
>
> select loc_description
> where loc_description like 'Joe^'s%'
> escape '^'
>
> It seems that I can use the escape character on anything other than a
 single
> quote mark. The problem is, in mu customer table, I need to track and
> search for names like "Joe's computers" or "Bill's hot dogs". Am I doing
 

> something wrong?
>
> Any responses would be appreciated
>
> Andre Allen
> NoSpam_at_interaccess.com
> to reply, Please replace "NoSpam" with "andre"
>
  Received on Wed Jul 02 1997 - 00:00:00 CDT