Number to Letters (Expression Function)


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”.

expression function - number to letters.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024