--CONVERT Function The CONVERT function is used to convert an expression from one data type to another, but it also allows for formatting when converting to certain data types, like dates. -- Convert ...

RIGHT() function will cut it off. In this following example, we are going to use 5 digits. SELECT RIGHT('00000' + CAST(c.CustomerID AS varchar(5)),5) AS CustomerID FROM Customers c; For good code ...