STR() function right-fills the decimal value with zeros


1>
2> -- STR() function right-fills the decimal value with zeros
3> SELECT STR(1, 6, 4)
4> GO

------
1.0000

(1 rows affected)
1>
2>

1.	STR: takes a numeric value and changes the data type to a char
2.	STR(100.325,7)
3.	Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will be left-padded with spaces
4.	STR() Function: converts a numeric value to a string
5.	STR(123.456789, 8, 4)

STR() function right-fills the decimal value with zeros : STR « String Functions « SQL Server / T-SQL