BIT_LENGTH Function
The BIT_LENGTH function returns an unsigned 64-bit value containing the bit length of the large object column or variable parameter. If the argument is NULL, BIT_LENGTH returns NULL.
BYTE_LENGTH Function
The BYTE_LENGTH function returns the number of bytes in a string.
BYTE_LENGTH64 Function
The BYTE_LENGTH64 function returns an unsigned 64-bit value containing the byte length of the large object column or variable parameter.
BYTE_SUBSTR64 and BYTE_SUBSTR Functions
The BYTE_SUBSTR64 and BYTE_SUBSTR functions return the byte substring of the large object column or variable parameter.
CHAR_LENGTH Function
The CHAR_LENGTH function returns a signed 32-bit value containing the character length of the LONG VARCHAR column or variable parameter, including the trailing blanks.
CHAR_LENGTH64 Function
The CHAR_LENGTH64 function returns an unsigned 64-bit value containing the character length of the LONG VARCHAR column or variable parameter, including the trailing blanks.
CHARINDEX Function
The CHARINDEX function returns a 64-bit signed integer containing the position of the first occurrence of the specified string in the large object column or variable parameter. For CHAR and VARCHAR columns, CHARINDEX returns a 32-bit signed integer position.
LOCATE Function
The LOCATE function returns a 64-bit signed integer containing the position of the specified string in the large object column or variable parameter. For CHAR and VARCHAR columns, LOCATE returns a 32-bit signed integer position.
OCTET_LENGTH Function
The OCTET_LENGTH function returns an unsigned 64-bit value containing the byte length of the large object column or variable parameter.
PATINDEX Function
The PATINDEX function returns a 64-bit unsigned integer containing the position of the first occurrence of the specified pattern in a LONG VARCHAR column or variable. For CHAR and VARCHAR columns, PATINDEX returns a 32-bit unsigned integer position.
SUBSTRING Function
The SUBSTRING function returns a variable-length character string of the LONG VARCHAR column or variable parameter. If any of the arguments are NULL, SUBSTRING returns NULL.
SUBSTRING64 Function
The SUBSTRING64 function returns a variable-length character string of the large object column or variable parameter.
User-Defined Function Support of Large Object Columns
Scalar and aggregate user-defined functions support large object data types LONG VARCHAR (CLOB) and LONG BINARY (BLOB) up to 4GB (gigabytes) as input parameters. LOB data types are not supported as output parameters.
Created August 28, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com