Saturday, 30 April 2016

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]
Posted by at

1 comment:

  1. Unknown5 August 2021 at 08:35

    what if you don't want to create a new column? Can this be used to alter the existing CustomerID field?

    ReplyDelete

Subscribe to: Post Comments (Atom)