update ID 1

[Cordeiro82]

Is there a way to update a 7 digit ID (7000210) to a 10 digit ID by adding preceding 0's to the number. So the new ID would be 0007000210.

Thanks,

Kevin

 

[lespaul]

not if you are storing it as a number. If you want to store the extra zeros you will need to change it to a text field. You could also just modify the format of the number to display the correct number of characters using the FORMAT command.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[Cordeiro82]

Hi Leslie... The ID is stored as text not a number. What do I do in that case?

 

[lespaul]

something like this should work:

update TableName SET FieldName = "000" + FieldName

I would test it first by using a query like:

SELECT FieldName, "000"+FieldName As NewField From TableName

if you get the results you are expecting, then run the update query.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design