Export (0) Print Expand All 22 out of 33 rated this helpful -
Rate this topic  STR (Transact-SQL)  Returns character data
converted from numeric data.  Topic link icon Transact-SQL
Syntax Conventions  STR ( float_expression [ , length [
, decimal ] ] )  Is an expression of approximate numeric (float)
data type with a decimal point.   Is the total length. This
includes decimal point, sign, digits, and spaces. The default is
10.   Is the number of places to the right of the decimal point.
decimal must be less than or equal to 16. If decimal is more
than 16 then the result is truncated to sixteen places to the
right of the decimal point.  If supplied, the values for length
and decimal parameters to STR should be positive. The number is
rounded to an integer by default or if the decimal parameter is
0. The specified length should be greater than or equal to the
part of the number before the decimal point plus the number's
sign (if any). A short float_expression is right-justified in
the specified length, and a lo