Numeric Expressions

Numeric expressions result in an integer value. Numeric expressions include:

  • Numeric constants. These can also be in binary form. For example:

    %%x = 23

    %%x = b'00101101'

  • Numeric expressions combined with arithmetic operators. Most of these operators take two operands, such as %%y + %%x. However, the unary minus operator has only one operand. For example:

    %%x = -%%y

  • A numeric function. For example:

    %%x = LENGTH(%%y)

Note: Numeric values in Enrichment cannot be more than 9 digits long. If you need to handle longer numbers you can use the SUBSTR function to break up the number into smaller parts that you can then work with.