Re: Escape Characters

Why not pick another character besides backslash for the escape character. Any character that does not appear elsewhere in the query should do the job.

Gene Hubert
Mr. SQL
http://www.skillspoint.com -
The trusted skills advisor to the Global 2000

On Fri, 21 Jul 2000 20:48:30 GMT, contrapositive <contrapositive_at_my-deja.com> wrote:

>Do escape characters specified per query apply to the entire query or
>just the LIKE clause(s)? I'm not working in an environment where I can
>easily test this.
>
>So given something like...
>
>"SELECT * FROM tbl WHERE x = 'C:\WINDOWS' AND y LIKE '%100\%%' ESCAPE
>'\';
>
>...does the escape character apply only to my LIKE clause or will it
>mess up the other clause since it contains a backslash? If it will mess
>things up, is there a way to run this query without making it too
>messy? I obviously only want it to affect the LIKE clause in this case.
>
>Thanks.
>
>-JK
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Jul 24 2000 - 00:00:00 CDT