format string of numbers with 0 prefixed sql server code example
Example: how to put 0 or 000 depending IDCustomer length in sql server
SELECT FORMAT(EmployeeID, '000000')
FROM dbo.RequestItems
WHERE ID=0
SELECT FORMAT(EmployeeID, '000000')
FROM dbo.RequestItems
WHERE ID=0