Reply to getting rid of trailing zeroes from a decimal output
Posted by David Greenberg on 01/31/06 16:48
Hi
I use SqlServer 2000
I am doing a select and sending the results, which is a cast() into
decimal (9,3), in an email to various other users of our system.
Problem is that a number like 95.2 is display as 95.200. Is there any
way I can trim it so that it will display 95.2 ?
David