String manipulation

CHAR – Convert number to character

107 views June 1, 2018 February 10, 2019 admin 0

Overview

This Custom Field converts a number to the corresponding character. Hexadecimal values can be specified but must be prefixed with ‘%’.

Syntax

CHAR(128), CHAR(%80)

Element Description
Character value Numeric value of character, e.g. 128, %80

Example

CHAR(78) returns N

CHAR(128) returns €

CHAR(%C6) returns Æ

See also

N/A

Was this helpful?