2 Replies Latest reply: Jul 20, 2011 12:56 PM by Donald Hutchins RSS

    Text() function in LOAD returns Scientific Notation

      I am loading a column using the Text() function.  The column contains integers.  But when I use the Text() function in the Load, the result is displayed as scientific notation (for example:  5.9489797e+008).

       

      LOAD

           Text(FIELDNAME)  As [New Field Name]

      RESIDENT  TableName;

       

      If (after the Load), I create a straight table and evalute the same field using an identical Text() expression, it evalutes just fine (not e-notation).

       

      Any ideas on why the Text() function in the LOAD evaluates to e-Notation?