Re: like %

["Alan Novick" <mida@xxxxxxxxxxxxxxx>]

OK, thanks.  what worked for me was:

WHERE CUSPO LIKE '%/%%' ESCAPE '/'


----- Original Message ----- 
From: "Mohondro, Kevin" <KMohondro@SalePoint.com>
To: <midrange-l@midrange.com>
Sent: Thursday, August 16, 2001 4:47 PM
Subject: RE: like %


Alan,

You have to use the escape clause with the like. For example, 

ITEM_DESC LIKE 'FIRST/%SECOND%' ESCAPE '/'

will find the description starting 'FIRST%SECOND'

HTH

-Moe
-------------------------------------------------------
Kevin R Mohondro                kmohondro@salepoint.com
Software Engineer                         (858)373-2012                
SalePoint Corporate Retail Solutions      San Diego, CA


-----Original Message-----
From: Alan Novick [mailto:mida@pressmantoy.com]
Sent: Thursday, August 16, 2001 1:25 PM
To: MidRange-L
Subject: like %


How do I select rows in SQL where a column contains the percent sign?
 
Thanks,
 
Alan Novick
Pressman Toy Corporation
New Brunswick, NJ
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com