STR SQL Server Example

SQL Server > Built-in Functions > STR

Converts number to varchar.

STR ( expression , length , decimal )

Example:

SELECT STR(123.45, 6, 1);

GO

result
 123.5