>They are set to OFF in both version.
Based on the SQL you provided, the following should make no difference, but in VFP 8 try:
SET ENGINEBEHAVIOR 70
before running the SQL. This sets the SQL Engine to VFP version 7. Setting it back to 80 is the default for VFP8.
Mark McCasland
Midlothian, TX USA