>I'm trying to stay with SQL. Thanks

You asked for the best way. If you're already on the record, it is inefficient for VFP to use Rushmore optimization to locate and then update that record.

>
>>http://fox.wikis.com/wc.dll?Wiki~ReplaceCommand~VFP
>>
>>>I'm on a record in a table. I want to do a SQL update to the current
>>>record.
>>>
>>>

>>>nRecId = Table.RecId
>>>
>>>UPDATE Table
>>>  SET Field = cValue
>>>  WHERE RecId = nRecId
>>>

>>>
>>>Is this the best way?