- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
The Number to Letters function (NUMBER_TO_LETTERS) returns capitalized latin characters that correspond to the number starting with 0.
The Number to Letters function has one required parameter:
Allowed Inputs: field value or positive number
Either use the use the Query Builder to choose a field that contains a positive number or use type a value to enter a positive number. While it is technically possible to use a text string with this function it is not recommended.
The output of the Number to Letters function is a string of capitalized latin characters corresponding to the number entered starting with 0 = A. A negative number will result in an empty string.
This function can be useful when creating simple alphabetic identifiers. For example the result of NUMBER_TO_LETTERS(0) is “A”, the result of NUMBER_TO_LETTERS(25) is “Z”, and the result of NUMBER_TO_LETTERS(30) would be “AE”.