>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,

This works for me:

SQLEXEC(lnHandle, [update appusers set lastname = 'O''Malley' where keyid = 2])