>I'm creating temporary tables with SQL Select. The resulting new tables have truncated long field names. This creates a problem, because if I do an APPEND FROM the temporary tables into the original tables the field names that do not match up are not copied. Any ideas for a solution.
Have you tried SELECTing into a cursor?
-cjh