>>Craig, Pardon me,
>>for completeness:
>>SET ANSI ON is equal to "=="
>>but
>>SET EXACT ON is not eqaul to "=="
>
>Hi Fabio,
>
>Yes, you are technically correct. However, Torrey is not using any SQL Commands in the example of the problem. So, I felt that Set Exact On was appropriate. It is definitely important that Visual FoxPro developers understand the difference between Set Exact On and Set Ansi on... I appreciate you bringing this into the discussion.

I write this because you put "==" into the discussion.

Here the VFP shows the best of it:

* SET EXACT is XBASE setting
* SET ANSI  is SQL setting

* relation
"SQL =="        is equal to "SET ANSI ON" 
"SET ANSI ON"   is equal to "SET EXACT ON"                             

Then "SET EXACT ON" is equal to "SQL =="
but  "SET EXACT ON" is not equal to "XBASE =="

I would have preferred:

=   SET  OFF = short match
==  SET  ON  = without trailing blank match
===            fully match