Depending on your database, may include LIKE and NOT LIKE. Use these operators when you are evaluating a text column or expression.
Table 51. Examples
| Example | Description |
|---|
S.PRODUCTS.DESCRIPTION LIKE '%Light% ' | Returns product descriptions containing the word "Light." For example, Light Bulbs and Desk Light. |
S.CUST_CONTACT.TITLE NOT LIKE '%Assistant% | Returns all customer contacts except those with the word "Assistant" in their title. |
S.EMP.ENAME LIKE 'J | Returns employees with five-letter names starting with J. |
Note:
String operators support the use of wildcard characters. The % sign means 0 or more characters. The _ sign represents any one character. For example, ENAME LIKE 'A%" returns only those rows where ENAME begins with the letter A.