LIKE()

Purpose

Function to compare two strings for similarities

Syntax

LIKE(<expC1>, <expC2>)

See Also

SOUNDEX(), STRTRAN()

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.