searching by a specific character
I want to search some data in a table that contains specific characters, for example :
in General Item Data, I want to search for Item Data that contains "EXP" characters.
The query results might be : "POT-0245-EXP", or "POT-7EXP-LCL" or "TEXP-0428-LCL"
Anybody knows what is the query/SQL syntax in BaaN to perform this searching ?