Function to extract scale part of a Decimal value

[suja.somu]

source column is a decimal data type of (7,2).

Data in source :

123.34
3456.45
12.45
8.1

Question is: what is the funtion that I can use to extract the scale part of the decimal

as in source



123.34 --> 34
3456.45 --> 45
12.45 --> 45
8.1 --> 1

[chandra.shekhar@tcs.com]

You can use any of the below functions to get the o/p :-

1) MantissaFromDecimal(<Column1>)
2) Field(<Column1>,'.',2)

[ray.wurlod]

Or even fieldname - Int(fieldname), multiplied by 10**x where x is the number of digits.

[suja.somu]

Thanks for the input. Closing the post as resolved.