Difference between revisions of "SET EXACT"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Determines how comparisons between two character expressions are performed | Determines how comparisons between two character expressions are performed | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | + | [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[RIGHT()]], [[RPAD()]], [[RTRIM()]], [[SET PCEXACT]], [[SOUNDEX()]], [[SUBSTR()]], [[TRIM()]] | |
| Line 23: | Line 16: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set exact off | set exact off | ||
use patrons index events | use patrons index events | ||
| Line 31: | Line 24: | ||
set exact on | set exact on | ||
// Lists only those people called "SMITH" | // Lists only those people called "SMITH" | ||
| − | list all for name = "SMITH"</ | + | list all for name = "SMITH"</code> |
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|EXACT]] | [[Category:Set_Commands|EXACT]] | ||
| + | [[Category:Environment]] | ||
| + | [[Category:Environment Set Commands]] | ||
Latest revision as of 15:44, 23 November 2009
Purpose
Determines how comparisons between two character expressions are performed
Syntax
SET EXACT ON | OFF | (<expL>)
See Also
LEFT(), LPAD(), LTRIM(), RIGHT(), RPAD(), RTRIM(), SET PCEXACT, 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 Server, Recital
