I'm not sure exactly what your looking for. But I think this may solve your problem.
SELECT myColumn FROM myTable WHERE myColumn LIKE "%'%" This will return all rows that contain ' in the myColumn -----Original Message----- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 11:05 AM To: CF-Talk Subject: sql help 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
