STR(number_to_convert, length_of_string, [number_of_decimal_places])8> SELECT STR(100.325,7,2)9> GO------- 100.33(1 rows affected)1>2> SELECT STR(100.325,7)3> GO------- 100(1 rows affected)