Share via

BINTOC( ) Function

  • Article

Converts an integer value to a binary character representation.

BINTOC(nExpression [, nSize])

Return Values

Character

Parameters

  • nExpression
    Specifies the integer value to convert.

  • nSize
    Specifies the length in characters of the returned character string.

    nSize also determines the value you can specify for nExpression. The following table lists the permissible values for nSize and the corresponding range of values for nExpression:

    nSize nExpression Range
    1 –128 to 127
    2 –32,768 to 32,767
    4 (default) –2,147,483,648 to 2,147,483,647

    If nSize is omitted, BINTOC( ) returns a character string composed of four characters.

Remarks

BINTOC( ) can be used to reduce the size of indexes for numeric fields containing integer data. For example, a numeric field named iPartCode might contain an integer value from 1 to 127, which corresponds to a parts classification code. BINTOC( ) lets you convert the value in the numeric field to a single character representation. For example, the following command creates an index with a one-character index key:

INDEX ON BINTOC(nPartCode,1) TAG PartCode

See Also

CTOBIN( ) Function | CREATEBINARY( ) Function | Integer Field Type