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 🙂
