Hi All,

Using A2003. I discovered a glitch in my database today that I traced
back to a text file import.

I already have a table in place to receive the text. One of the table
fields "CLM" is a 20 character text field, zero-length OK, not required.
The text file I use to populate the table contains a 10-character
element in the CLM position. The actual values look something like this:
  WC02123456
  WC03987654
  0000979797
  0004321000

What I found today is all the CLM values that look numeric
("0004321000") were dropped and CLM is Null. Moreover, /only/ those
kinds of values were dropped. The alphanumeric values are all there.

Has anyone seen this or have ideas how to prevent it? Note I cannot make
CLM a required field.

I can go back and fill in the missing values in another way, but the
extra step seems unnecessary, and this mysterious omission sort of
breaks my confidence.