A.4.3 SQL Pattern Matching Operator
SQL has a very simple pattern-matching operator. The 'like' operator supports two pattern characters:
% |
Match any character sequence |
? |
Match any single character. |
company like 'I%'
This condition matches any string starting with an 'I' character.
skill like 'C??'
This condition matches any string starting with a 'C' character, followed by two arbitrary characters. Similar to the 'in' operator, a logic negation can be added with a short hand:
skill not like 'C%'
| << A.4.2 In Operator | © 1996-2013 InetSoft Technology Corporation (v11.4) | A.4.4 Existence Operator >> |