![New database option WD_DELETE_METHOD [CR 415547]](arrow-left.gif){kind=icon}
![String search functions for large object columns [CR 415543]](arrow-right.gif){kind=icon}
Sybase IQ 12.7 ESD #3 includes support of the LIKE predicate on LONG VARCHAR (CLOB) columns. Formerly, LIKE predicates were supported only on CHAR and VARCHAR columns.
Using the LIKE predicate, you can now search for a pattern on a LONG VARCHAR column. All patterns of 126 characters or less are supported. Patterns of length greater than 254 characters are not supported. Some patterns of length between 127 and 254 characters are supported, depending on the contents of the pattern.
Note that LIKE predicates are not supported
on LONG BINARY (BLOB) columns.
If you attempt to search for a pattern in a LONG BINARY column using
a LIKE predicate, the error “Invalid
data type comparison in predicate...” is
returned.
