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])
Frederick Kusin
NetBase Development Group
3746 Folsom Street
San Francisco, CA. 94110
www.netbasegroup.com