FLOAT

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
  X   X

Converts a number into the floating point representation of the number, as if the value were assigned to a FLOAT field. The format appears below:

FLOAT(x)

In DB2 compatibility mode, the parameter x cannot be a string. In XDB mode, x can be a string.