like the regex solutions above..if you don't need any quotes in the database whatsoever (which is a good idea anyway), strip them all, including escaped quotes \\' etc. and then quote all. But, you should realy be told by the source of the text whether it's already quoted or not: my first database theorem: SHIT in = SHIT out.