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
Function to extract scale part of a Decimal value
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: