Skip to content
Related Articles

Related Articles

STR() Function in SQL Server
  • Last Updated : 24 Sep, 2020

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

Syntax :

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

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :