Skip to Content
0
Former Member
Oct 07, 2009 at 06:10 PM

Decimal question

17 Views

Cr 2008, SQL Server 08

I have a string field that holds values like 1.0, 2.5, 5.0.

What I need to do is if the decimal is a 0 then only display the whole number and strip of the .0, if it is like 2.5 then display 2.5.

I have not figured out how to do this.

thanks,

GJ