convert char into integer function?

[bhargav_dd]

How can I convert a varchar data type into a numeric data type then insert it into a varchar field in a datatabase.

For example, I need to clean up the leading zeros of this string "00000000000009700477" then insert it into a field with charvar data type.

Note that I cannot change the charvar data type to integer or numeric data type in the target table.

Example:

Source (flat file) leading zeros in numeric Data ---> Taget table: dont want leading zeros in varchar field.

00000000000009700477 want to see only 9700477

00000000000000000890 want to see only 890

Is there an interger convert function that can be used in transformer to accomplist this task?

Thanks.

[Nripendra Chand]

Use Asinteger function.

[ray.wurlod]

Trim the leading zeroes. There's no need to be concerned about converting data type. Use the three-argument version of the Trim() function.