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. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, February 26, 2007 11:32 AM To: CF-Talk Subject: Query of Queries Question Hi, Anyone know how to force a LIKE comparison in a QofQ query to look for literals of the following special characters: % _ [ ] ^ All of the above are characters used in a LIKE comparison, but my string has several of them in it, so I need to 'escape' them somehow. I'm on MX 6.1. Thanks! Sincerely, Dave Phillips President WebTech Staffing, LLC [EMAIL PROTECTED] (817) 473-2119 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
