You can convert exact and approximate numeric data to a character type.
If the new type is too short to accommodate the entire string, an insufficient space error
is generated. For example, the following conversion tries to store a 5-character string in a
1-character type:
select convert(char(1), 12.34)
Insufficient result space for explicit conversion
of NUMERIC value '12.34' to a CHAR field.
When converting float data to a character type, the new type should be at
least 25 characters long.
Note:
The str function may be preferable to convert or
cast when making conversions, because it provides more control over
conversions and avoids errors.