Change autonumber length

[critical5]

I have a table and with an increment ID which id now SN001 but i would like to add an extra 0 to make it SN0001...any idea how to do this??

I tried update like this
UPDATE CUSTOMERS
SET CUSTOMER_ID = "SN0+[CUSTOMER_ID,4]"

Thanks

 

[hvass]

update customers
set customer_id=concat(substring(customer_id,1,3),'0',substring(customer_id,4,2))

 

[r937]

autonumber? increment? how do you populate new values into this column? just curious

r937.com | rudy.ca