Tried that....I did finally find it in the docs. You can actually specify your own escape character. So it's like this:
SELECT * FROM whatever WHERE what LIKE '%95\%%' ESCAPE '\' This will find anything that has 95% in the resultset 'whatever', column 'what'. It doesn't matter what character you use. Of course, you want to make sure that character is not in your text you are querying....so I ended up doing this: SELECT * FROM whatever WHERE what LIKE '%95#chr(9)#%%' ESCAPE '#chr(9)#' Ascii Character 9 is the TAB character and in my circumstance it works well because I'm comparing URLs and they don't contain tab characters. Hope this helps someone else who runs into the same thing! Dave -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, February 26, 2007 10:36 AM To: CF-Talk Subject: RE: Query of Queries Question This is just a guess, but you can try putting either a "\" or a "'" before the characters that needs to be escaped?? LIKE 'foo\%bar' Or maybe LIKE 'foo'%bar' The single quote is only a guess because single quote escaped another single quote. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
