Like Predicate
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a pattern-match comparison.
Syntax
|
<row value predicand> <character like predicate part 2> [ IGNORE CASE ] |
|
[ NOT ] LIKE <character pattern> [ ESCAPE escape-character ] |
<character pattern> ::= <character value expression>
Notes
| ♦ | The data types of the row value predicand, character pattern and escape-character shall be comparable character string types. |
| ♦ | The predicate evaluates to TRUE if the row value predicand string matches the character pattern string, else to FALSE. |
| ♦ | Underscore ( _ ) is used as a wildcard character representing an arbitrary single character specifier at the location in character pattern. |
| ♦ | Percent ( % ) is used as a wildcard character representing an arbitrary string specifier at the location in character pattern. |
| ♦ | The ESCAPE clause causes the character following the escape-character to be treated as a normal character, which allows the special wildcard characters to be used as single character specifiers in character pattern. |
| ♦ | If any of the row value predicand, character pattern or escape-character values are null, then the predicate evaluates to UNKNOWN. |
| ♦ | The NOT operator inverts the meaning of the comparison and is equal to: |
NOT ( <row value predicand> LIKE <character pattern> [ ESCAPE escape-character ] )
| ♦ | IGNORE CASE makes the comparison operation case-insensitive. |
Examples
| 1) | The following example selects students whose first name starts with 'Jo': |
SELECT studentName, gender
FROM students
WHERE studentName LIKE 'Jo%'
| 2) | The following example selects students whose first name has an 'o' in the second position: |
SELECT studentName, gender
FROM students
WHERE studentName LIKE '_o%'
| 3) | The following example selects orders with '10%' as a portion of the notes column value: |
SELECT orderID, notes
FROM orders
WHERE notes LIKE '%10\%%' ESCAPE '\'
Conformance
|
SQL:2003 standard NexusDB extensions |
- - - |
Core SQL Feature F281 "LIKE enhancements" IGNORE CASE |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm