Mega Code Archive

 

Categories / MSSQL / String Functions

 

Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will

1> 2> --Specifying an overall length greater than the length of the value, decimal point, 3> --and the decimal value, the result will be left-padded with spaces 4> 5> SELECT STR(1, 12, 4) 6> GO ------------       1.0000 (1 rows affected) 1> 2>