drew.allen (11/1/2016)
snowprincess42073 (10/31/2016)
Hi all,I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should be 4.67 and not 4.68.
I tried round, decimal, cast, etc. but each function converts the value to 4.68.
Can anybody let me know the syntax so that I get the exact values after decimal.
Best Regards,
Htet Htet
First, this thread is almost a decade old.
Second, your post is an exact copy of the original post in this thread except for the name.
Please do not resurrect old threads unless you have something valuable to contribute.
Drew
Lighten up, Drew. This isn't stackoverflow... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.