Operators

                   

Expand/Collapse all Show/Hide All

The following operators can be used:

Mathematical operators

String operators

 

Mathematical Operators

Use mathematical operators to perform numeric calculations. You can also include numeric literals by typing numeric characters within a numeric expression, usually separated by one or more operators. The following special characters are used to perform mathematical operations:

 

Expand/Collapse item  Table: Special Characters

When evaluating a numeric expression, the operators are evaluated based on the following precedence: ^, * or /, + or -. If two operators of equal precedence occur, execution is performed from left to right.

Expand or collapse item Example

 

Expand or collapse item Example

 

String Operators

Two operators can be used to combine string variables and reference substrings. In addition to using control variable names, you can use string literals enclosed in quotation marks in an expression. You can also create data values that contain specific ASCII characters by using hexadecimal digits (0-9, or A-F) enclosed by "$".

Expand or collapse item Example

 

Expand/Collapse item  Substrings

 

Expand or collapse item String Concatenation

 

Expand or collapse item  String Functions