How to remove the leading zero's.

[stiwari]

Hi All,


I have to remove leading zero's from a varchar field....the scenario is like...i have the value's like 000876 and 000etywe now i have to remove the leading from only those records where it follows numeric value after the zero's....

It should be 876 and 000etywe

can any one tell me how to do this??



Thanks in advance
stiwari

[kumar_s]

Use Trim() function. Or Convert() if you think, 0's will be only in leading end.

[DSbox61]

to remove leading zeros..it is straight forward..u need to use Trim function...but to decide where to to use that function based on ur condition, u need to use If then else statement and another function Num with it....this function num will return 1 if the given string can be converted to a number...

hope this helps...

[meena]

Hi,
Try this:

Code: Select all

Trim ("000876 and 000etywe",'0',L)
L:-Removes leading occurrences of character.

[ray.wurlod]

And the other part of the requirement is a simple If..Then..Else

Code: Select all

If Num(InLink.TheColumn) Then Trim(InLink.TheColumn, "0", "L") Else InLink.TheColumn