Check out example codes for "how to put 0 or 000 depending IDCustomer length in sql server". It will help you in understanding the concepts better.

Code Example 1

SELECT FORMAT(EmployeeID, '000000')
FROM dbo.RequestItems
WHERE ID=0

Learn ReactJs, React Native from akashmittal.com