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

Aug 7 2019 7:52 AM
i have created a Table with Column Datatype as Int
below is the Data inserted into it
00012,0012,000000136.after Inserting.How to Write a Query to identify Leading Zero's are Inserted into Particular Column or not
 
Ex:-
Create Table Test4(EmpSal int)
insert into Test4 Values(00012),(0012),(000000126),(0000135)

Answers (2)