--------------------------------------------------
SELECT STR(123.45, 6, 1)
GO

output:
------
 123.5

(1 row(s) affected)

--------------------------------------------------
SELECT STR(123.45, 2, 2)
GO

output:
--
**

(1 row(s) affected)


--------------------------------------------------
SELECT STR (FLOOR (123.45), 8, 3)
GO

--------
 123.000

(1 row(s) affected)