Difference between revisions of "LIKE()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) |
||
| Line 9: | Line 9: | ||
==Description== | ==Description== | ||
| − | The LIKE() function is used to compare two character strings for matching qualities. The <expC1> specifies the matching pattern to look for. The <expC2> specifies the string in which to look. The <expC1> accepts "wildcard" characters with which to construct the pattern. Wildcard characters may represent upper case or lower case characters, but specific characters are case sensitive. The | + | The LIKE() function is used to compare two character strings for matching qualities. The <expC1> specifies the matching pattern to look for. The <expC2> specifies the string in which to look. The <expC1> accepts "wildcard" characters with which to construct the pattern. Wildcard characters may represent upper case or lower case characters, but specific characters are case sensitive. The following wildcard characters are supported: |
{| class="wikitable" | {| class="wikitable" | ||
Revision as of 13:20, 19 December 2012
Contents
Purpose
Function to compare two strings for similarities
Syntax
LIKE(<expC1>, <expC2>)
See Also
Description
The LIKE() function is used to compare two character strings for matching qualities. The <expC1> specifies the matching pattern to look for. The <expC2> specifies the string in which to look. The <expC1> accepts "wildcard" characters with which to construct the pattern. Wildcard characters may represent upper case or lower case characters, but specific characters are case sensitive. The following wildcard characters are supported:
| Characters | Description |
|---|---|
| ? | Matches any one character |
| % | Synonymous with ? |
| * | Matches zero or more characters |
If the LIKE() function is used in SQL statements, the following wildcard characters are available:
| Characters | Description |
|---|---|
| _ | Matches any one character |
| % | Matches zero or more characters |
The LIKE() function returns .T. if a matching pattern is found, or .F. otherwise.
Example
?like("*Lianja*", "This is Lianja") .T.
