TTdbDataSet.Replace
TTdbDataSet

Replaces field values in a range of rows.

procedure Replace(const Filter, Fields, Expressions: string): LongInt;

Description
Replace sets the values of the Fields to the values calculated by Expressions for all records that meet the Filter's condition. The Expressions are evaluated in the context of each record.

Example
The following example appends the digit nine to all phone numbers from Reading, GB:
Replace('Phone like "+44 118*", 'Phone', 'Phone + "9"');