Editing external DB query
 

Have an external database which is accessed via ODBC. The table I am
accessing has 5 columns and I only want three of them of which the first
column is the key. I am, however performing an area scan as I am not
selecting on the key column but requesting all rows in which the second
column is equal to a certain value. The third column is described as char 7.
When the data is returned to me, I choose to receive it in the Edit Query
dialog box. The data in the third column is being displayed as having only 6
characters instead of 7, truncating the right most character.

Has anyone encountered a similar problem and if so, where you able to
resolve the problem? and how was the problem resolved?