I have few records in a column of length 6. Now I want to update the last 2 digits of them with other number. eg:- 12360, 453560, 6760, 124560 and 6060 these are the records I have. Now I want to update only the last 2 digits '60' with 58 (no other places to be updated). Is it possible to do? Can anyone please help with query. Thanks in advance!