I use it OFF, but then I make exact comparisons using == and using the full length of the field, not just the length of the string.
In example, if the field is C(20) and the string is "word", I first assign PADR(lcString, 20) and then I search it, so I make it independent of SET ANSI.
El 8/4/2017 1:20 a. m., mbsoftwaresolutions@mbsoftwaresolutions.com escribió:
Just ran across an instance where I had SET EXACT ON but didn't specify SET ANSI (for which the default is OFF). After seeing a query for CHICAGO contain results including others like CHICAGO HEIGHTS, I investigated and thought my SET EXACT was OFF. Nope, it was ON but my SET ANSI was OFF. Setting it to ON gave me the results I wanted.
I'm just surprised this never bit me in all my years doing VFP; I guess because I've usually been using a RDBMS (like MySQL/MariaDB).
[excessive quoting removed by server]