I looked into the ROUND() function as you guys suggested. Maybe my implementation is off because while it rounds the value, it leaves on all the trailing zeros after the rounding takes place.

And since the goal is to make this reader friendly, the trailing zeros aren't helping.

Any ideas how to get rid of these trailing zeros?

DECLARE @Gains AS DECIMAL(18,8)

SET @Gains=RAND()

SELECT

@Gains

, ROUND(@Gains, 4)

Gave me:

0.671448080.67140000