Here's the problem in VFP with an SQL Update Statement.

Person's name = Bob "Skip" O'Hara
Id = 5

You wish to create an SQL update statment to update a VFP table.

Here's the code:
lcName = [Bob "Skip" O'Hara]

lcSql = "UPDATE nametbl SET name = "+lcName+" WHERE id = 5"

&lcSql

The macro causes an error to occur.
What can be done to get around this probelm? My code is being used for both VFP and SQL.

Any thoughts......