>I do not buy the arguement that 70 gives you WRONG data. So everyone coding in Fox and VFP prior to VFP8 were getting wrong data? Thousands of systems were built on VFP6, VFP7 and prior versions and nobody complained about wrong data. But yes, I am making the changes where I am able, but some older systems - that work - will not be given the hours needed to make them SQL standard.

Hi Brenda,

It's not an argumnent but fact that 70 could give incorrect or inconsistent results depending on the data. Check Message #941774, for example. Long before SET ENGINEBEHAVIOR was introduced, people were asking here on UT and other forums and NG why such selects doesn't produce result they expected.