Adding 01 to End of SSN

[pumba78]

Hello,

Can anyone tell me how to add 01 to the end of social security numbers? Sometimes I have to do this to hundreds of records and apart from it being time consuming, it is a real pain. Any help will be greatly appreciated.

Thanks.

[MAK]

--if ssn is a char or varchar
update tablename set ssn = ssn+'01'

--if ssn is an int or bigint

update tablename set ssn =
convert(int,convert(varchar(20),ssn)+'01')