No. It is 2 consecutive single quotes.
>But isn't that a double quote in O'Malley?
>
>
>
>>>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])
Mark McCasland
Midlothian, TX USA