I have just learned, much to my chagrin, about SET ANSI ON. Having learned about its existence, I want to make sure I get it right ...

It appears that when using '=' within a SELECT statement and SET ANSI OFF, the trailing spaces are ignored, and the comparison is only made up to the length of the shortest string. This "KP3 " = "KP31 ", even though normal VFP string comparison doesn't work this way.

However, setting SET ANSI ON will compare the strings to their entire lengths, so such mis-matches do not occur. Is this correct? Is there any other effect of SET ANSI ON?

Thanks in advance.