Well, you escape a single quote with an extra single quote, so you could give this a shot:
SELECT textCol FROM myTable WHERE textCol like '%''%' Jamie On Fri, 8 Aug 2003 11:04:56 -0400, in cf-talk you wrote: >i would like to write a sql query that finds everywhere an ' occurs in a >field (ie. 's). does anyone know the syntax for this type of statement? >thanks. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
