vijay reddy

vijay reddy

  • NA
  • 13
  • 4.3k

in dynamic sql removing leading zeros

Jul 11 2016 1:22 PM
Hi,
 
i have
select id, name, address from emp. in that id value is comming from other source like '00123'  value.
 
i want to remove leading  zeros in dynamic sql query. how can i procede.
 
id data type is varchar(8). once if i remove the leading zeros.
 
at run time my data like 'AB123', how can i find the value like.
 
thanks
vijay 
 

Answers (3)