Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Urgent - SQL Help

Urgent - SQL Help

From: Shashank Tripathi <shanx_at_shanx.com>
Date: Mon, 24 Jan 2000 08:59:17 GMT
Message-ID: <388c1413.30840954@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.

Shashank Tripathi
http://shanx.com Received on Mon Jan 24 2000 - 02:59:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US