MDAC 2.5 SDK - ODBC Desktop Database Drivers
If data in a column is longer than 255 characters, the LIKE comparison will be based only on the first 255 characters.
A LIKE used in a procedure is supported only with constant patterns. The Desktop Database Drivers support SQL-92 LIKE pattern matching.
Use of an escape clause in a LIKE predicate is not supported.
A LIKE comparison should not be performed on a column containing data of a numeric or float data type. The results may be unpredictable. For more information, see the Microsoft Jet Database Engine Programmer's Guide.