DECLARE @DECIMAL_VAL DECIMAL(10, 4)
SET @DECIMAL_VAL = 3244.12
SELECT CAST(REPLACE(STR(@DECIMAL_VAL, 11, 4), SPACE(1), '0') AS varchar(10))

This page was last updated on May 01, 2006 04:28 PM.