Replace sting

[souadouert]

i want to replace zero with '' in the IDs, but just zero at the beginning of the ID in load script

000574 ---> 574

0574-->547

02540 -->2540

[Anil_Babu_Samineni]

Why second row only should change? Because, Of only one 0 is there?

[Anonymous · Accepted solution]

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

[sunny_talwar]

May be this

Replace(LTrim(Replace(String, '0', ' ')), ' ', '0') as String

[souadouert]

i want delete just the zero at the beginning 

[souadouert]

thank you

[Anil_Babu_Samineni]

Multiply with 1 to field