Format

If A = 1, B = 3

SELECT ((A/B)*100) AS Pct ....

How do format Pct so that the calculated field will be displayed as 33% instead of 33.333333?

Thanks. Received on Mon Apr 01 2002 - 16:42:37 CST