Difference between revisions of "LIKE()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to compare two strings for similarities
 
Function to compare two strings for similarities
Line 31: 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:
  
  
 
{| class="wikitable"
 
{| class="wikitable"
!Characters||
+
!Characters||Description
==Description==
+
 
|-
 
|-
 
|_||Matches any one character
 
|_||Matches any one character
Line 56: Line 51:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data]]
 +
[[Category:String Data Functions]]

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