Difference between revisions of "LIKE Predicate"

From Recital Documentation Wiki
Jump to: navigation, search
Line 51: Line 51:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
[[Category:Reference]]
 

Revision as of 15:28, 13 March 2009

LIKE PREDICATE

Class

SQL Applications


Purpose

Special predicate


Syntax

<expression1> [NOT] LIKE <expression2>


See Also

PREDICATES, INSERT, SELECT, UPDATE


Description

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


Operator Description
_ Any single character
% Zero or more characters


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


Example

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


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer