Chapter 5 Objects
The Expression field in the Customize Columns and Filter dialog box is not case-sensitive and accepts the following wildcards:
| Wildcard | Description |
|---|---|
| * | Any string (from none to any number of characters) |
| ? | Any character |
| \* | * is a normal character |
| \? | ? is a normal character |
The following are examples of filter expressions
| Expression | String values allowed |
|---|---|
| W* | Work
Washington |
| *CODE | AREA CODE
COUNTRY CODE CITY CODE |
| ????ER | Writer
Seller |
| *_emp_??? | div_emp_fun (code for the function of the employee in the division)
_emp_idn (code for the identification of the employee in the division) |
| *\? | Is this book ready for production? |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |