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.
SAP 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.