Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will
1> 2> --Specifying an overall length greater than the length of the value, decimal point, 3> --and the decimal value, the result will be left-padded with spaces 4> 5> SELECT STR(1, 12, 4) 6> GO ------------ 1.0000 (1 rows affected) 1> 2>