Home Forums SQL Server 2005 SQL Server 2005 General Discussion Displaying Fewer Decimal Places RE: Displaying Fewer Decimal Places
SQLBOT
SSCrazy Eights
Points: 8014
More actions
January 8, 2009 at 10:27 am
#923520
Aha! Decimal must be immune to a true round::
Try this one!
DECLARE @Gains AS float
SET @Gains=RAND()
SELECT
@Gains
, ROUND(@Gains, 4)
so maybe in your code you could cast to a float and round it.
~BOT
Craig Outcalt