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 >>