How about something like this?

declare @x table (TransId varchar(10))

insert @x

(TransId)

values ('4461'),

('14130')

select TransId

,'CP' + right('000000000000' + TransId, 12)

from @x x