View source for LIKE Predicate

==Purpose==
Special predicate


==Syntax==
<expression1> [NOT] LIKE <expression2>


==See Also==
[[SQL Predicates|PREDICATES]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]]


==Description==
LIKE is a special predicate to evaluate whether the specified <expression1> matches <expression2>.  The <expression2> can contain the following wildcards:



{| class="wikitable"
!Operator||Description
|-
|_||Any single character
|-
|%||Zero or more characters
|-
|}


The optional NOT evaluates whether the specified <expression1> does not match <expression2>.


==Example==
<code lang="recital">

EXEC SQL
SELECT name, address, balance, cost*1.15
FROM accounts
WHERE paid_date < date() AND name LIKE "%inc%"
ORDER BY name, paid_date;
</code>


==Products==
Recital, Recital Server
[[Category:Documentation]]
[[Category:SQL]]