![SUBSTRING function [String]](arrow-left.gif){kind=icon}
![SUM function [Aggregate]](arrow-right.gif){kind=icon}
The SUBSTRING64 function returns a variable-length character string of the large object column or variable parameter.
SUBSTRING64 supports searching LONG VARCHAR and LONG BINARY columns and LONG VARCHAR and LONG BINARY variables of any size of data. Currently, a SQL variable can hold up to 2GB - 1 in length.
See Chapter 9, “Function Support” in Unstructured Data Analytics in Sybase IQ.
Users must be specifically licensed to use the large object data types LONG BINARY and LONG VARCHAR. For details on the Unstructured Data Analytics Option, see Unstructured Data Analytics in Sybase IQ.
