Data converted to scientific notation

[cliff_clayman]

I have a field that is a text field in my SQL table.  I went to great lengths to ensure this field gets assigned as text in the database.  When I add it to my Qlikview report, some of the values are still showing as scientific notation.  I load many other fields into the report and I just do a SELECT * FROM TableName.  How can I LOAD the field as TEXT in the script and just call out the field(s) I want to make as text?

[cliff_clayman]

That is correct.

[srchilukoori]

In the above script, the second load is concatenated to first and gets dropped. You need to use a 'No Concatenate' statement.

[sunny_talwar]

Thanks for pointing out, but the script above is SELECT * and not SELECT GLAccts... so in this case it isn't required anymore.

Best,

Sunny