The right operand of the LIKE comparison operation is a table field.

Only a literal (a parameter) or an expression over literals can be the right operand of the LIKE and ESCAPE comparison operation. Mask characters are the «_» ‑ any character and the «%» ‑ a sequence of any characters only.

Noncompliant Code Example

It is forbidden to use a table field (a catalog attribute) in a query as the right operand of the LIKE and ESCAPE comparison operation.

SELECT
    StocksBalanceAndTurnovers.Warehouse
FROM
    AccumulationRegister.Stocks.BalanceAndTurnovers AS StocksBalanceAndTurnovers
WHERE
    StocksBalanceAndTurnovers.Warehouse LIKE Table.Field

Compliant Solution

When using LIKE and ESCAPE in query texts, use only constant string literals or query parameters.

SELECT
    StocksBalanceAndTurnovers.Warehouse
FROM
    AccumulationRegister.Stocks.BalanceAndTurnovers AS StocksBalanceAndTurnovers
WHERE
    StocksBalanceAndTurnovers.Warehouse LIKE "123%!%" ESCAPE "!"

See