QlikView is converting text to a number when it should not

[#1]

This is a very critical and annoying problem.

I have a table where Code field can have values like 1234 and 01234. They are actually different values but when I load to QlikView it only loads one of them (the first that is find).

So, in other words, let's say this is the value I have in the database:

Code

----------

01234

789

05647

1234

0789

5647

When I load them to QlikView, I get this only:

Code

-----------

01234
789

05647

If I add a character to the field, like a |, it does return all values but I cannot have that as a solution.

So, how to force QlikView to NOT convert the values to anything and really understand them as unique?

[johnca]

Duh...preceeding load. Must have Friday on my mind.