Open In App

STR() Function in SQL Server

Improve
Improve
Like Article
Like
Save
Share
Report

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

Last Updated : 24 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads