Quotes as part of the string in a SQL statement

[amarti44]

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

 

[braindead2]

brackets like "0[']farriel" should do it