>>>What other effects does ENGINEBEHAVIOR have? Are other violations ignored? Or do some
>>>SQL statements produce different results?
>>
>>Better to check the help file than ask me. :-)
>
>OK, I will. - It turns out there are several minor differences, including memo fields not
>supported under certain circumstances, and differences in the evaluation of the LIKE clause.
>For those that don't have VFP8 installed (like me), the details can be found at
>http://msdn.microsoft.com/library/en-us/dv_foxhelp/html/vfp8_lngsetenginebehaviorcommand.asp.

Thanks for posting the link, Hilmar: I was really worried about giving out incorrect info on that.