Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

SELECT STR(123 456789, 8, 4)

1>  SELECT STR(123.456789, 8, 4) 2> GO -------- 123.4568 (1 rows affected)