STR takes a numeric value and changes the data type to a char. : STR « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. STR
STR(number_to_convert, length_of_string, [number_of_decimal_places])

8> SELECT STR(100.325,7,2)
9> GO

-------
 100.33

(1 rows affected)
1>
2> SELECT STR(100.325,7)
3> GO

-------
    100

(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)