>>>No, I don't think ANSI has a "SET ENGINEBEHAVIOR". It is the VFP8 IMPLEMENTATION that I would rather have seen done differently.
>>
>>Actually, it does. SQL Server has a compatibility stored procedure to set the compatibility level. This was begun in SQL Server 7.0. 6.5 handled things like including fields in the select stateament that weren't in the group by clause when dealing with aggregate functions.
>
>Sure for SQL Server. But not ANSI, surely.
SQL Server didn't, like Fox, exhibit as high degree of compliance with ANSI-92 as, perhaps, it should have. What both the SQL Server team and the Fox team did was give a method that allowed existing SQL to function as it had before.
George
Ubi caritas et amor, deus ibi est