This question is locked. New answers and comments are not allowed.
Tomasz M.Lipiński
Top achievements
Rank 1
Rank 1
Tomasz M.Lipiński
asked on 11 Mar 2010, 01:44 AM
Hi,
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:
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?
Regards
Tomasz
1 Answer, 1 is accepted
0
Hi Tomasz M.Lipiński,
Yes, you are right. We added this to our TODO list and will provide an option to find such strings in one of the following builds.
Thank you for bringing this to us.
Best wishes,
Alexander
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Yes, you are right. We added this to our TODO list and will provide an option to find such strings in one of the following builds.
Thank you for bringing this to us.
Best wishes,
Alexander
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.