View Incident Report

Serious

Reported By: Helmut Schiefer
Reported On: 9/25/2001
For: Version 3.01 Build 1

# 881 CAST Function Not Working Properly when Converting Floating-Point Numbers to Text

I have notice some changes between version 2.11 and 3.01, detailed below.

select floatfield, CAST( floatfield as CHARACTER(10)) as text
..

with 2.11:

1.22   1.22
2        2

with 3.01:

1.22   1.22000000
2        2

Resolution

Fixed Problem on 9/25/2001 in version 3.02 build 1

More Support Options