I am trying to UPDATE a SQL table that has single quotes and appostrophies inside the field1. I can't use double quotes around my character field. Does anyone know of a solution for this.

lcSQLUpdate = "update table1 set field1 = '"+foxvar1+"' where sqlvar=x"

Thanks,