MSSQL - Add leading zeros (0) to the integer

Watch this example on YouTube

Here I will add up to 20 zeros

SELECT  replicate ( '0', 20- len([CustomerID])) + cast (CustomerID as varchar(50)) as accNum
  FROM [TEST].[dbo].[Customers]