In WHERE clauses of the SELECT statement, you can use LONG BINARY columns only in IS NULL and IS NOT NULL expressions, in addition to the BYTE_LENGTH64, BYTE_SUBSTR64, BYTE_SUBSTR, BIT_LENGTH, OCTET_LENGTH, CHARINDEX, and LOCATE functions.
You cannot use LONG BINARY columns in the SELECT statement clauses ORDER BY, GROUP BY, and HAVING or with the DISTINCT keyword.
Sybase IQ does not support LIKE predicates on LONG
BINARY (BLOB) columns or variables. Searching for a pattern
in a LONG BINARY column using a LIKE predicate returns
the error Invalid data type comparison in predicate.
