Re: SQL 'ESCAPE' Problem

You can't escape single quotes - I assume it's something to do with them being the string delimiter. Try this instead:

where loc_description like 'Joe''s%'

Just double them up.

/*+ The opinions expressed here are mine and do not necessarily reflect those of Oracle Corporation
*/

Andre Allen (NoSpam_at_interaccess.com) wrote:
: 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