Difference between revisions of "LIKE()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 27: Line 27:
  
  
If the LIKE() function is used in SQL mode (SET SQL ON or embedded EXEC SQL statements), the following wildcard characters are available:
+
If the LIKE() function is used in SQL statements, the following wildcard characters are available:
  
  

Latest revision as of 15:56, 5 July 2011

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 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.


Products

Recital Server, Recital