When using this SQL Statement, do not forget the specific where clause to the record you are updating or you might update the entire table in error. Ensure you have isolated a unique record with the where clause.
1. Update <table>
2. Set <column name> = ‘correct data’
3. Where <column name> = ‘current value’ and <column name> = ‘current value’
For example,(1) Update _obj_2, (2) Set IDX_SSN =
‘111-22-3333’ (3) Where objectid = 2 and IDX_Name = ‘John Doe’