BASE

The BASE function converts a number into the specified base and returns a text representation of the calculated value.

BASE Syntax

Use the following syntax when incorporating BASE functions in queries:

BASE(number, base [,min_length])

Where number is the integer (0 to 2^53) to convert, and base is the radix (2 to 36) that you want to convert number to. The optional min_length argument is the minimum length (0 to 255) of the returned string. If the result is shorter than the minimum length, leading zeros are added to the result so that it reaches the minimum length.