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

• Next in forum: Re: How to find first not null value in column
• Prev in forum: Re: Data Connections for SQL Server Express in Visual Studio Express
• Thread view: getting rid of trailing zeroes from a decimal output

[Reply to this message]