Have a look at `big buddies?

skyparks

example:
A B C
a 1 2
b 2 3
c 3 4
1d 5 6
1e 6 7
1f 8 9
Why doesn't the table become (bottom):
A B C
1a 1 2
1b 2 3
1c 3 4
1d 5 6
1e 6 7
1f 8 9

qunimmd

select A = '1' + right (A, 1) form yTable

fanfan1980

create table T (A varchar (10), B int, C int)
insert T select 'a', 1, 2
union all select 'b', 2, 3
union all select 'c', 3, 4
union all select '1d', 5, 6
union all select '1e', 6, 7
union all select '1f', 8, 9

update T set A = '1' + A
where charindex ('1', A) <> 1

select * from T

--result
A B C
---------- ----------- -----------
1a 1 2
1b 2 3
1c 3 4
1d 5 6
1e 6 7
1f 8 9

(6 row (s) affected)

githzerai

update on the table
set on the table. A = '1' + A
where substring (A, 1,1) <> '1'