SELECT STR(123.456789, 8, 4) : STR « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. STR
1> SELECT STR(123.456789, 8, 4)
2> GO

--------
123.4568

(1 rows affected)








12.20.STR
12.20.1.STR() converts a numeric value to a string
12.20.2.STR takes a numeric value and changes the data type to a char.
12.20.3.STR(float_expression, character_length, number_of_decimal_places)
12.20.4.SELECT STR(123.456789, 8, 4)
12.20.5.SELECT STR(1, 6, 4)
12.20.6.SELECT STR(1, 12, 4)