Write a Query to identify Leading Zero's are inserted or not

Before all, open this table in SQL Server Management Studio and see whether the table is really storing the values with leading zeros or only storing numeric values. i.e. whether stored as 00012 or just 12. Please paste the screen shot of management studio for below items.

 

1. Design of the specific column

2. Data stored in that column

Please check below link it may resolve your issue

 

https://stackoverflow.com/questions/34224932/how-can-i-determine-if-a-field-has-leading-zeroes-in-sql-server-2008-r2

 

https://blog.sqlauthority.com/2012/11/22/sql-server-removing-leading-zeros-from-column-in-table-part-2/