Skip to content
Related Articles

Related Articles

Improve Article

STR() Function in SQL Server

  • Last Updated : 24 Sep, 2020

The STR() function converts a numeric value to a character value.

Syntax :

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

STR(float_expression [, length [, decimal]])

Parameter : This method accepts three parameters as mentioned above and described below :

  • float_expression : It is a numeric expression that evaluates to an approximate number with a decimal point.
  • length : It is the total length of the returned string.
  • decimal : It is the number of places to the right of the decimal point.

Returns : It returns a number as a string.



Example-1 :

SELECT STR(246.573, 6, 2);

Output :

246.57



Example-2 :

SELECT STR(246.573, 3, 3);

Output :

246



Example-3 :

SELECT STR(246.573, 2, 2);

Output :

**



Example-4 :

SELECT STR(246.573, 8, 4);

Output :

246.5730
My Personal Notes arrow_drop_up
Recommended Articles
Page :