Why not just use the VBScript function replace?<BR><BR>'Replace all single apostrophes with two in str<BR>str = Replace(str, "'", "''")<BR><BR>'Replace any quotes with double quotes<BR>str = Replace(str, """", """""")<BR><BR>Tech docs on Replace at:<BR>http://help.activeserverpages.com/iishelp/VBScript/htm/vbs170.htm
Because I dont want to replace every occurence. For example--<BR>"SELECT * FROM tblName WHERE Favorites='Romeo's' And FirstName='Sam's'" ---- I just want to fix the apostrophe. Not to mention I'd like to get cozy with Regular Expressions. I'm sure they'll come in handy once I am more familiar with them.