2. ASPRunnerPro General questions
  3. too many numbers in percentages
This topic is locked

too many numbers in percentages

 		6/29/2008 10:17:55 AM
ASPRunnerPro General questions
author

I have a table that displays percentages and I need to know if there is a way to limit the number of digits to the right of the decimal point. I'm using ASPRunnerPro 5.2 build 423.
The display is now: 79.3691389599318% for example. 79.37% would be the best.
Thanks in advance.
jfr 6/30/2008

Hi,
In the Edit SQL query screen, you put rather then just the Column, the following;
CONVERT(NUMERIC(18,2), 'Your Column name here')
In the Alias you put the original Column name (or any other, what you choose) and the outcome will be a Numeric 2 digital exact number.
Hope this helps,
John