+---------------------------------+
|            SET ANSI             |
+---------------------------------+
SET ANSI ON | OFF

-----------------------------------
Specify how SQL string comparisons are made.
Default value - OFF
-----------------------------------

SET ANSI determines whether shorter of two strings is padded with blanks
when comparison is made.  SET ANSI has no effect on the == operator; the
shorter string is always padded with blanks for the comparison when you
use ==.

ON
        Shorter string is padded with blanks (ASCII character 32) to length of
longer string.

OFF
        Shorter string is not padded with blanks for comparison.

SET ANSI and RQBE
        The RQBE window builds a SQL SELECT command when you create a query.
When creating join and filter conditions, if you choose the Like or
Exactly Like options the = or == operator is respectively included in
the generated SELECT command.  Therefore, the ANSI setting can affect
the results of queries you create and perform in the RQBE window.

The following table shows the effect of the ANSI setting on comparisons
using the = and == operators.

Comparison               ANSI ON   ANSI OFF
-----------------------------------


-----------------------------------

See Also:  CREATE QUERY, MODIFY QUERY, SET EXACT, SELECT - SQL, SQL

-----------------------------------