Export (0) Print
Expand All
Expand Minimize
0 out of 3 rated this helpful - Rate this topic

SET EXACT Command

Specifies rules that Visual FoxPro uses when comparing two strings of different lengths.

NoteNote

Unlike SET ANSI, SET EXACT does not apply to Visual FoxPro SQL commands. For more information, see SET ANSI Command.


SET EXACT ON | OFF

Parameters

ON

Specifies that expressions must match character for character when comparing character data, or byte for byte when comparing binary data, to be equivalent.

NoteNote

To match the length of the longer expression, the shorter of the two expressions is padded to the right with spaces or zero (0) bytes. However, any trailing spaces or zero bytes in the expressions are disregarded in the comparison.

OFF

Specifies that expressions must match character for character when comparing character data, or byte for byte when comparing binary data, until the end of the expression on the right side is reached to be equivalent. (Default)

If both strings are the same length, SET EXACT has no effect.

SET EXACT is scoped to the current data session.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.