Exact and approximate numeric data can be converted 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.
