SQL Server STR() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL Server STR() Function




❮ SQL Server Functions



Example


Return a number as a string:



SELECT STR(185);

Try it Yourself »

Definition and Usage


The STR() function returns a number as a string.


Syntax



STR(number, length, decimals)


Parameter Values









Parameter Description
number 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

Technical Details




Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data
Warehouse, Parallel Data Warehouse

More Examples



Example


Return a number as a string:



SELECT STR(185.5);

Try it Yourself »



Example


Return a number as a string:



SELECT STR(185.476, 6, 2);

Try it Yourself »




❮ SQL Server Functions


-