Difference between revisions of "SET EXACT"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[RIGHT()]], [[RPAD()]], [[RTRIM()]], [[SOUNDEX()]], [[SUBSTR()]], [[TRIM()]] | + | [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[RIGHT()]], [[RPAD()]], [[RTRIM()]], [[SET STRCOMPARE]], [[SOUNDEX()]], [[SUBSTR()]], [[TRIM()]] |
==Description== | ==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. | 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. | ||
+ | |||
+ | Lianja v2.0 | ||
+ | By default, SET STRCOMPARE is ON in Lianja SQL Server, Lianja Cloud Server, Lianja App Builder and App Center. To use SET EXACT OFF for partial string comparisons, SET STRCOMPARE should also be set OFF. | ||
==Example== | ==Example== |
Latest revision as of 10:27, 2 July 2015
Contents
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 STRCOMPARE, 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.
Lianja v2.0 By default, SET STRCOMPARE is ON in Lianja SQL Server, Lianja Cloud Server, Lianja App Builder and App Center. To use SET EXACT OFF for partial string comparisons, SET STRCOMPARE should also be set 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"