I'm not sure about the problem you are experiencing with the @GET, but you should be able to force the SQL to the full 50 characters by SELECT'ing:
SELECT PADR(, 50, ' ') AS ...
You would also want to include the other fields, but this should force the width of the errant field out to 50 characters. HTH
>My problem concerns a DBF file with the following defect... > >I have a particular field which is 50 characters long...When I try to read this with an @get command, it works well EXCEPT on one particular record where the field size is much smaller than 50 -> 13. > >The rest of the file is ok. > > >Is it possible for just one record to get corrupted? I have a program that fixes corrupted dbfs but it only seems to fix invalid headers. > >I have also tried to make a copy of the file by a select-sql statement but then all records have that field 13 character long. > >Any ideas would be greatly appreciated... > >Thanks in Advance, > >Mark