Hi:
I hope somebody can help me. I'm new to SQL and I'm trying to send an SQL string in VB like this:
MySQL = "SELECT * FROM Visitor WHERE Last_name LIKE 'O'Farriel'.....
where O'Farriel is a last name with a single quote as part of the last name.
How can I make the SQL statement to understand the entire last name and not only 'O'.
Thanks in Advance
Alberto
I hope somebody can help me. I'm new to SQL and I'm trying to send an SQL string in VB like this:
MySQL = "SELECT * FROM Visitor WHERE Last_name LIKE 'O'Farriel'.....
where O'Farriel is a last name with a single quote as part of the last name.
How can I make the SQL statement to understand the entire last name and not only 'O'.
Thanks in Advance
Alberto