SQL Server Zero Pad Left | SQLServer.info
In a recent project, I had the task of padding a number with zeros. SQL Server doesn’t have a built in Zero Pad Left function. SQL Server does have a Right function. You can use this to create a zero padded left string. SELECT RIGHT('0000000000' + @TextT
www.sqlserver.info