Decimal Validation
Posted: Tue Feb 07, 2012 5:42 pm
I have a column from a text file as '0000000045788999' and I need to do the following:
1. need to perform a decimal validation on it for decimal[18,2].
2. For this I am dividing it by 100 to see if its a valid decimal
3. then set T or F based on the outcome.
When I divide by 100, its becoming as 4.5789e10^5. So, its taking an exponent form and this is failing the validation. How to make it avoid taking the exponent form. Thank you.
1. need to perform a decimal validation on it for decimal[18,2].
2. For this I am dividing it by 100 to see if its a valid decimal
3. then set T or F based on the outcome.
When I divide by 100, its becoming as 4.5789e10^5. So, its taking an exponent form and this is failing the validation. How to make it avoid taking the exponent form. Thank you.