title: How to add 0s to a numeric attribute so that all numbers in the attribute are 10 digits in SQL
body: <p>I have a numeric attribute that contains IDs in a table in my database. However, the IDs are not of the same length (e.g. 54261, 73284619, 3723). I want all of them to be in the same length by adding 0s in front of them so that all of them are 10 digits (e.g. 000054261, 0073284619, 0000003723). I'm wondering if I can write a SQL query to achieve this or I have to do this in Excel.</p>