Rosi Sreenivasa Reddy

Rosi Sreenivasa Reddy

  • 1.8k
  • 137
  • 35.4k

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)

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (2)