Global Replace Command (VisData Utility Menu)

Allows you to create an SQL update statement to update a column in all of the records in a selected table that satisfy the conditions you define.

Dialog Box Options

Table List

Lists the tables from which you can select a table to update.

Field List

Lists the fields in the selected table from which you can select a field (column) to update.

Replace With

Sets the replacement value for the column data. Single quotation marks will be added for you if the field type is Text.

Criteria

Sets the criteria for the records you want to select and update (leave blank for all rows).