I know why foxpro makes the trailing spaces... It has to do with the .dbf format.

The problem is that when I scatter the fields in preperation to inserting them into another table, I get trailing blanks on the fields. Then when I insert them into another data base engine (access or sql anywhere) I have errors because the blanks are there.

Is there any way to scatter without the blanks? Short of m.myfield = alltrim(myfield)

Thanks!