Quote as a part of 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

 

[tlbroadbent]

Put two single quotes together.

MySQL = "SELECT * FROM Visitor WHERE Last_name LIKE 'O''Farriel'....." Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.