Specifications

CHAPTER 23 Operators and Expressions
Users Guide 621
For example, the following expression for the Background.Color property of
the Salary column displays salaries in red for employees with last names
beginning with F and displays all other salaries in white:
If(emp_lname LIKE'F%',RGB(255,0,0),RGB(255,255,255))
Escape keyword
If you need to use the % or _ characters as part of the string, you can use the
escape keyword to indicate that the character is part of the string. For example,
the _ character in the following filter string is part of the string to be searched
for, but is treated as a wildcard:
comment LIKE ~'%o_a15progress%~'
The escape keyword designates any character as an escape character (do not
use a character that is part of the string you want to match). In the following
example, the asterisk (*) character is inserted before the _ character and
designated as an escape character, so that the _ character is treated as part of
the string to be matched:
comment like ~'%o*_a15progress%~' escape ~'*~'
BETWEEN and NOT
BETWEEN operators
Use BETWEEN to check if a value is within a range of values. Use NOT
BETWEEN to check if a value is not in a range of values. The range of values
includes the boundary values that specify the range.
For example, the following expression for the Background.Color property of
the Salary column displays salaries in red when an employee’s salary is
between $50,000 and $100,000 and displays all other salaries in white:
If(salary BETWEEN 50000 AND 100000, RGB(255,0,0),
RGB(255,255,255))
You can use the BETWEEN and NOT BETWEEN operators with string
values. For example, if the following expression is used for the Visual property
of a column, column values display only for departments listed alphabetically
between Finance and Sales:
If(dept_name BETWEEN 'Finance' AND 'Sales',1,0)
The % or _ characters can be used when you are using string values with the
BETWEEN and NOT BETWEEN operators. This example might include
more department listings than the previous example:
If(dept_name BETWEEN 'F%' AND 'S%',1,0)
You can also use the BETWEEN and NOT BETWEEN operators with
methods. For example:
GetRow( ) BETWEEN 5 AND 8