To create a text expression

Text expressions are useful for formatting the results of text-related queries, for example, in tables.

1. Select the command for which you want to create an expression.
2. In the expression area, do one of the following:
   • Enter a text function manually.
   • Click Text Function and select the function you want.
3. Click Property. In the Property list, select the property for the function.
4. Specify any arguments required by the function, enclosed in single quotation marks.

   For example, if you are padding the right side of a text string with two asterisks, the expression looks like this one:

   

   For text expressions, the property is within parentheses, followed by any arguments within single quotation marks.

   If you are translating a text string from mixed case to lowercase, the expression looks like this one:

   Lower (PRODUCT_NAME)

5. Specify any further conditions for the expression.

   To create a complex property evaluation, insert an AND or OR operator, and then insert another operator, property, and value combination.

   For help with any expression element, see Creating Expressions - Reference.

6. Click OK to apply the expression.