Binary Functions
The following binary function support BYTE and VARBYTE values for X100 tables.
BYTEEXTRACT
BYTEEXTRACT(c1,n)
Result type: BYTE
Returns the nth byte of c1. If n is larger than the length of the string, the result is a byte of ASCII 0.
Note: This function does not support LONG VARCHAR, LONG NVARCHAR, or LONG BYTE arguments.
There are also a few SQL functions that support BYTE and VARBYTE as operands:
CHARACTER_LENGTH,
CONCAT,
HEX,
LEFT,
LENGTH,
OCTET_LENGTH,
REPEAT,
REPLACE,
RIGHT,
RTRIM,
SHIFT,
SUBSTRING.
Last modified date: 12/19/2024