>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?
Never made a serious tests, but I think the REPLACE will be faster, if you work only on current record.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.