Difference between revisions of "LIKE()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to compare two strings for similarities | Function to compare two strings for similarities | ||
| − | |||
==Syntax== | ==Syntax== | ||
LIKE(<expC1>, <expC2>) | LIKE(<expC1>, <expC2>) | ||
| − | |||
==See Also== | ==See Also== | ||
[[SOUNDEX()]], [[STRTRAN()]] | [[SOUNDEX()]], [[STRTRAN()]] | ||
| − | |||
==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 Recital/4GL supports the following wildcard characters: | 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 Recital/4GL supports the following wildcard characters: | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 25: | Line 21: | ||
|- | |- | ||
|} | |} | ||
| − | |||
If the LIKE() function is used in SQL statements, the following wildcard characters are available: | If the LIKE() function is used in SQL statements, the following wildcard characters are available: | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 38: | Line 32: | ||
|- | |- | ||
|} | |} | ||
| − | |||
The LIKE() function returns .T. if a matching pattern is found, or .F. otherwise. | The LIKE() function returns .T. if a matching pattern is found, or .F. otherwise. | ||
| − | |||
==Example== | ==Example== | ||
| Line 50: | Line 42: | ||
| − | + | ||
| − | + | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 12:16, 7 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 Recital/4GL supports the following wildcard characters:
| 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("*Recital*", "This is Recital") .T.
