String Functions MSSQL Tutorial

1>  SELECT STR(123.456789, 8, 4)
2> GO
--------
123.4568
(1 rows affected)