oh god.. i hope that helps me.. thanks i was having a problem like that but with a text insert in postgresql.. i couldnt insert ' correctly.. so if i try replacing ' with [''�`] in the insert it might work?
----- Original Message ----- From: "Justin Greene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 1:55 PM Subject: Searching for ' with like clause with SQL Server > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
