How to increment by one in SQL table
Posted on 2008-01-24
I have a table (tblRef) that has a column: Ref_No which is a 4 digit number (first one is 1000) as well as other data, I would to be able to make Ref_No 5 digits instead of 4, is there a way to run an update query that will make all of the values in the Ref_No column increment to 5 digits?
Currently, the field is data type: int, what do I have to change it to so I can insert 5 digits instead of 4.
Currently Ref_No has the following data:
I would like them to be changed to:
Any ideas? Thanks you in advance!