SQL statement problem

I have a variable declared as a string (Dim myComment as String)

myComment is equal to a cell on my spreadsheet. If the user types in that cell special characters such as quotations or single quotes, my code produces an syntax error. My code is trying to execute an SQL statement that includes the variable myComment. How do I get the SQL statement to execute?

For example: mySQL = "SELECT tblContractorDataOnly.FName FROM tblContractorDataOnly WHERE FName = "Mary's"). In this example "Mary's" is what is in the cell. myComment = "Mary's".

My SQL statement won't execute because of the single quote in Mary's.

What can I do?

I don't quite understand but I'll try again.

I have a variable declared as a string

Please Login or Register  to view this content.

myComment is equal to a cell on my spreadsheet. If the user types in that cell special characters such as quotations or single quotes, my code produces an syntax error. My code is trying to execute an SQL statement that includes the variable myComment. How do I get the SQL statement to execute?

For example:

Please Login or Register  to view this content.

In this example "Mary's" is what is in the cell. myComment equals "Mary's".

My SQL statement won't execute because of the single quote in Mary's.

What can I do?

Does anyone have a clue of what I'm asking? If so, please help.

Hi

I'm guessing that your code would be along the lines of

Please Login or Register  to view this content.

If so then try it as

Please Login or Register  to view this content.

Some SQL requires that the item be surrounded by a single quote character and this may allow it to work. If it doesn't then try using the REPLACE or SUBSTITUTE on the myComment variable to change the ' to \' and still surround with the '. Depending on your instance of SQL, you may have to find whatever the character is that specifies a special character follows. Sometimes \, or it may be ~

HTH

rylo