Values of float are truncated when converted to any integer type.
When converting from float or real to character data, the string function STR( ) is usually a better choice than CAST( ), because STR( ) enables more control over formatting. For more information, see Functions.