Mega Code Archive
Categories
/
MSSQL
/
String Functions
STR() function right-fills the decimal value with zeros
1> 2> -- STR() function right-fills the decimal value with zeros 3> SELECT STR(1, 6, 4) 4> GO ------ 1.0000 (1 rows affected) 1> 2>