I am loading data from a comma-delimited file to a hash file, so I can do quick look-ups on it. The problem I'm having is that some of the data gets reformated when I move it over, for no apparent reason.
Example: I have account numbers that need to be 4 digits. Some of them have leading zeroes, though. 0001, 0002, 0003, etc. When I move the data to the has file, it drops the zeroes. I do not want it to drop the zeroes, but can't see how to stop that from happening.
Any info/help would be greatly appreciated. Thanks!
Loading data to a hash file
Moderators: chulett, rschirm, roy
Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>