sql server - How to convert int to char with leading zeros ...

sql-server stored-procedures ... You can also use FORMAT() function introduced in SQL Server 2012. .... select right('000' + convert(varchar(3),id),3) from table example declare @i int ...

stackoverflow.com