SQL

SELECT *
FROM Customers
WHERE CustomerID like '%ANA%'

SPL

A2 Create full-text index on CustomerID column.
A3 Perform like match query according to index field. Note: If the value being matched is an English word or a number, the match string should contain at least three characters; if the value under match is a Chinese character, there isn’t restriction on the number of characters in the match string.