SET EXACT
From Recital Documentation Wiki
Revision as of 13:21, 11 March 2009 by Yvonnemilne (Talk | contribs)
Contents
SET EXACT
Class
Environment
Purpose
Determines how comparisons between two character expressions are performed
Syntax
SET EXACT ON | OFF | (<expL>)
See Also
SET PCEXACT, LEFT(), LTRIM(), LPAD(), RIGHT(), RPAD(), RTRIM(), SOUNDEX(), SUBSTR(), TRIM()
Description
If SET EXACT is OFF, strings are compared up to the length of the shortest string. If SET EXACT is ON, the strings compared must be an exact match in both characters and length. By default, EXACT is OFF.
Example
set exact off use patrons index events // Lists all people beginning with "SMITH" // SMITH, SMITHWAITE SMITHSON etc. list all for name = "SMITH" set exact on // Lists only those people called "SMITH" list all for name = "SMITH"
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer