Convert varchar to decimal

[times29]

Hi,
I am trying to convert varchar(05) to decimal(5) my doing as below but i am still getting 05

Code: Select all

Trim(Stringtodecimal(link.AA),"0","L")

Thanks

[ray.wurlod]

You can't Trim a Decimal.

The leading zeroes are displayed by DataStage to verify that precision and scale are being handled properly.

You can only remove the zeroes if the data type is string (or, I believe, integer) of some sort.

[chulett]

What's your ultimate target?

[ssnegi]

Trim it first and then convert to decimal.

Stringtodecimal(Trim(link.AA,"0","L"))

[rsomiset]

Still it would be decimal datatype and hence the leading zeroes would be available.