Just came across something interesting that I thought I would pass along. We were writing a query along the lines of
select * from column where value like 'o'brien' This of course will not work and needs to be select * from column where value like 'o''brien' however this was not working either. After much head beating and hair pulling we realized that our data was imported from word and used ´ rather than ' so the query needed to read select * from column where value like 'o[''´`]brien' to actually find the data. Of course it would have been nice if the data was just clean. Hope this saves someone some grief one day :-) Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists