LIKE predicate limitations

  • Article

If data in a column is longer than 255 characters, the LIKE comparison is 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 isn't supported.

A LIKE comparison shouldn't be performed on a column containing data of a numeric or float data type. The results might be unpredictable. For more information, see the Microsoft Jet Database Engine Programmer's Guide.