Difference between revisions of "LIKE()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 45: | Line 45: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
[[Category:Search Functions]] | [[Category:Search Functions]] | ||
Latest revision as of 06:39, 4 February 2013
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.
