SQL 'ESCAPE' Problem

From: Andre Allen <NoSpam_at_interaccess.com>
Date: 1997/06/28
Message-ID: <5p47ir$2ak_002@news.interaccess.com>#1/1

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 Sat Jun 28 1997 - 00:00:00 CDT