Doh! I forgot that you have to use double single quotes in your SQL syntax. Change your code tot he following:

Dim sQuote As String, sDQuote As String

sDQuote = Chr$(34)
sQuote = Chr$(39) & Chr$(39)
quoteIt = Replace(sStr, sDQuote, sQuote)


This will make a '' instead of a '. Are you trying to do this in Access or in Visual Basic? I am assuming Visual Basic since it is under this thread.