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.
![[]](/support/modules/ubercart/uc_cart/images/bullet-arrow-up.gif "Expand cart block."){kind=icon}
| 7x | SLA - Silver (add years in quantity field) | AUD 6,300.00 |
| 1x | NexusDB AWE DLL (1 installation; binary) | AUD 330.00 |
| 1x | The Full Monty Pack | AUD 1,800.00 |
| 1x | NexusDB Professional Edition | AUD 1,400.00 |
| 2x | Memory Manager V4 | AUD 702.00 |
| 4x | SLA - Gold (add years in quantity field) | AUD 10,666.68 |
| 1x | Visual Studio Standard Pack | AUD 500.00 |
| 2x | NexusDB AWE DLL (site license; binary) | AUD 4,600.00 |
| 1x | Nexus Quality Suite v1 | AUD 550.00 |
| 4x | SLA - Platinum (add years in quantity field) | AUD 16,000.00 |
| 1x | NexusDB Embedded Source | AUD 430.00 |
| 1x | NexusDB Server License Plugin | AUD 250.00 |
| 1x | NexusDB Starter Edition DCU | AUD 150.00 |
| 1x | NexusDB AWE DLL (10 installations; binary) | AUD 1,950.00 |
| 28 Items | Total: AUD 45,628.68 |
| (View cart) (Checkout) | |
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