Leading zero is removed

[#1]

Hi,

I have this problem with leading zeros that are automatically removed from the input. I actually want the leading zeros to remain intact.

As an example script:

Test:
load *;
LOAD * INLINE [
Code
001
01
1
002
02
2
];

If I load this, it will only show me 2 rows (001 and 002), what I would like to see is: (001, 01, 1, 002, 02 and 2). Any suggestions?

The problem is actually from when I load data from an Oracle DB using ODBC, the above is just serving as an example 🙂