Re: Urgent - SQL Help

From: Hein van Vroonhoven <Hein.vanVroonhoven_at_akzonobel.com>
Date: Mon, 24 Jan 2000 10:16:22 +0100
Message-ID: <86h592$ote$1@news1.xs4all.nl>

WHERE NAME LIKE 'abc''\\\%s'

success

Shashank Tripathi wrote in message
<388c1413.30840954_at_news.netvigator.com>...
>Hello
>
>I need some help with SQL. How would I search for a field that has the
>following value:
>
> abc'\%s
>
>I am trying the following SQL:
>
> SELECT * FROM TABLE
> WHERE NAME = 'abc''\\\%s'
> escape '\'
>
>but it doesnt seem to be working!
>
>Would appreciate any help with this..
>
>Thanks!
>Shanx
>
>
>
>Its better to waste your youth than to do nothing with it.
> -- Buddha
>
>Shashank Tripathi
>http://shanx.com
Received on Mon Jan 24 2000 - 03:16:22 CST