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.
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
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 "!"