Hello Friends
I have a record in a MySQL Table that has a field that contains a string that has a single quotation (i.e., Mark's). Now when I attempt to retrieve the record based upon the field that contains the string with the single quotation I get an error
Code:
strSQL = "SELECT * FROM MyTable WHERE Field_1 = 'Mark's'"
I tried formating the string using the Escape Character '\' and two single quotations, with no success:
Code:
strSQL = "SELECT * FROM MyTable WHERE Field_1 = 'Mark\'s'"
Code:
strSQL = "SELECT * FROM MyTable WHERE Field_1 = 'Mark
When I execute the above SQL against the table I get the following error. I am able to save any string with either the single or double quotations.
Reguards
Nikhil
SQL Querry Help2
Linear Mode
