UPDATE number SET num = replace(num, '28', '39')
UPDATE number SET num = '39'+substring(num, 3, len(num))
where
where substring(num, 1, 2) = '28';
UPDATE number SET num= '39'+''+right(num, Len(num)-2)
UPDATE number SET num= Replace(num, Substring(num, 1, 2), 39)
Substring(num, 1, 2)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)