Help Desk

Submit a ticket My Tickets

Leading Zeros

How can I ensure that a column will be represented as text to maintain incoming leading zeros? 

I have a chain that reads in a file, and in the list file content I can see the leading zeros. I run a query and then they are no longer visible, it is as though the column gets converted to integer on import. How can I tell advanced query to keep the column as text so the leading zeros stay?

Login to post a comment