in dynamic sql removing leading zeros

Question

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