I have a table (Table1) that has a varchar(5) as it's PK (Table1ID)
I need to do a mass update to Table1ID and add 1000 to each record as if the field was an integer. I need to retain the leading zero for thoses records less than 10000. I'm thinking a cast or convert is needed but not sure how to proceed.
Here is what I tried but just got a concatenation of the values, but it is the idea of what I need.
SET Table1ID = Table1ID + '1000'
WHERE Table1ID BETWEEN '01000' AND '01410'