The BCDTOTEXT function converts the digits in a BCD (Binary Coded Decimal) item to a text item containing the digits of the BCD-encoded item as a string of characters.

BCDTOTEXT (single-text-expression)
BCDTOTEXT (BCD_item_to_convert)
A single text item

BCD_item_to_convert is converted from BCD format to a text string containing the digits of the BCD-encoded value as a string of characters.

Numbers in BCD format have two decimal digits in each byte. Each half-byte, therefore, can contain a binary value from 0000 (which represents the digit 0) through 1001, which represents the digit 9). Based on this definition, the following behavior applies:

  • If any half-byte of the BCD number contains the binary value 1101 or 1111, that half-byte is ignored.
  • If the BCD item contains the binary value 1010, 1011, 1100, or 1110, the output of the function is "none".


  • BCDTOTEXT ( Qty:Item )

    If Qty is x`1234', the result is 1234.

  • BCDTOTEXT ( DiscountAmt )

    If DiscountAmt is x`0123', the result is 0123.

  • BCDTOTEXT ( TotalDollars )

    If Total is x`F123', the result is 123.

Related functions