STR Function in SQL Server: Explained

The article will explore and show you how to use STR function to return character data converted from digital data in SQL Server.

Describe

The STR function in SQL Server returns a string representing a number specified in the function.

Syntax

To use STR function in SQL Server, we use the following syntax:

 STR(number, length, decimal) 

Parameters :

• number: Numeric value to convert into a string.
• length: The length of the returned string, including all digits, decimal numbers,. If the length is not specified, it will default to 10.
• decimal: The number of decimal places will show in the result string and cannot exceed 16. If the decimal number is not specified, it will default to 0.

Note :

• STR will round the result if there are not enough length and decimal parameters to display the output string based on the parameters provided.
• Function STR can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

As an example,

Take a look and explore some examples of STR functions in SQL Server.

 SELECT STR(123); 
 Result: '123' 
 
 SELECT STR(123.5); 
 Result: '124' (k?t qu? ???c làm tròn vì v? trí th?p phân m?c ??nh là 0) 
 
 SELECT STR(123.5, 5); 
 Result: '124' (k?t qu? ???c làm tròn vì v? trí th?p phân m?c ??nh là 0) 
 
 SELECT STR(123.5, 5, 1); 
 Result: '123.5' 
 
 SELECT STR(123.456, 7, 3); 
 Result: '123.456' 
 
 SELECT STR(123.456, 7, 2); 
 Result: '123.46' (k?t qu? ???c làm tròn vì v? trí th?p phân ???c ??t thành 2) 
 
 SELECT STR(123.456, 7, 1); 
 Result: '123.5' (k?t qu? ???c làm tròn vì v? trí th?p phân ???c ??t thành 1) 
 
 SELECT STR(123.456, 7, 0); 
 Result: '123' (k?t qu? ???c làm tròn vì v? trí th?p phân ???c ??t thành 0) 
 
 SELECT STR(123.456, 7); 
 Result: '123' (k?t qu? ???c làm tròn vì v? trí th?p phân m?c ??nh là 0) 

Next lesson: STUFF function in SQL Server