>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.