Difference between revisions of "SQL Relational operators"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 44: | Line 44: | ||
|$||True if <expression1> is a sub string of <expression2>. Both <expression1> and <expression2>must be character strings. | |$||True if <expression1> is a sub string of <expression2>. Both <expression1> and <expression2>must be character strings. | ||
|- | |- | ||
| − | ||||True if <expression2> is a sub string of <expression1>. Both <expression1> and <expression2>must be character strings. | + | |<nowiki>|</nowiki>||True if <expression2> is a sub string of <expression1>. Both <expression1> and <expression2>must be character strings. |
|- | |- | ||
|==||True if <expression1> and <expression2> match, otherwise False. Both <expression1> and <expression2>must be character strings. The <expression2> can contain the wildcards below. | |==||True if <expression1> and <expression2> match, otherwise False. Both <expression1> and <expression2>must be character strings. The <expression2> can contain the wildcards below. | ||
| Line 55: | Line 55: | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | + | |_||Any single character | |
|- | |- | ||
|%||Zero or more characters | |%||Zero or more characters | ||
Revision as of 12:52, 13 March 2009
Contents
SQL RELATIONAL OPERATORS
Class
SQL Applications
Purpose
Relational Operators
Syntax
<expression1> operator <expression2>
See Also
INSERT, SQL OPERATORS, SELECT, UPDATE
Description
Relational Operators compare two expressions and evaluate to either True or False.
| Operator | Description |
|---|---|
| = | True if <expression1> and <expression2> are equal, otherwise False |
| < | True if <expression1> is less than <expression2>, otherwise False |
| <= | True if <expression1> is less than or equal to <expression2>, otherwise False |
| > | True if <expression1> is greater than the <expression2>, otherwise False |
| >= | True if <expression1> is greater than or equal to <expression2>, otherwise False |
| <> | True if <expression1> and <expression2> are not equal, otherwise False |
| != | True if <expression1> and <expression2> are not equal, otherwise False |
| # | True if <expression1> and <expression2> are not equal, otherwise False |
| $ | True if <expression1> is a sub string of <expression2>. Both <expression1> and <expression2>must be character strings. |
| | | True if <expression2> is a sub string of <expression1>. Both <expression1> and <expression2>must be character strings. |
| == | True if <expression1> and <expression2> match, otherwise False. Both <expression1> and <expression2>must be character strings. The <expression2> can contain the wildcards below. |
Wildcards for == pattern matching:
| _ | Any single character |
| % | Zero or more characters |
Example
EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE paid_date = date() ORDER BY name, paid_date; EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE paid_date <= date() ORDER BY name, paid_date; EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE paid_date <> date() ORDER BY name, paid_date; EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE name == "%inc%" ORDER BY name, paid_date; EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE name | "inc" ORDER BY name, paid_date; EXEC SQL SELECT name, address, balance, cost*1.15 FROM accounts WHERE name $ "BigCo inc, BigCo plc" ORDER BY name, paid_date;
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
