Loading lesson path
Concept visual
Start at both ends
Return a number as a string:
SELECT STR(185);The STR() function returns a number as a string.
number, length, decimals )
Required. The number to convert to a string length Optional. The length of the returning string. Default value is 10 decimals Optional. The number of decimals to display in the returning string. Default value is 0
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return a number as a string:
SELECT STR(185.5);Return a number as a string:
SELECT STR(185.476, 6, 2);❮ SQL Server Functions