It is said in the documentation that in OQL WHERE clauses * matches to any string of characters. I've made some experiments with wildcards in OQL and the conclusion is that while processing an OQL query, * is mechanically replaced by %. I've come to this because:
- % also matches to any string
- a clause: "xx like '*[*]*'" doesn't match * in my data but perfectly matches % .... it poduces exactly the same result as: "xx like '%[%]%'" ...
- the same concerns ? that is equivalent to _ (in this case looking for [?] finds _ ...)
Am I right? And if "yes" - are you going to fix it any way?