Difference between revisions of "SET EXACT"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Environment
 
 
 
 
==Purpose==
 
==Purpose==
 
Determines how comparisons between two character expressions are performed
 
Determines how comparisons between two character expressions are performed
Line 32: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
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