AD
Administrator
Syncfusion Team
December 13, 2005 01:25 AM UTC
It looks like a capitalization problem. The behavior that I see is that if the values in the column start with an uppercase, then then Match operator fails to find it no matter whether the match string starts upper or lower case.
I was able to find any occurrence of a string by using the LIKE operator with the asterick wildcard around the string (instead of the match operator). Will this work for you?
[Col1] like ''*Syncfu*''
AD
Administrator
Syncfusion Team
December 13, 2005 05:27 AM UTC
Yes, using LIKE should work for me.
thanks,
>It looks like a capitalization problem. The behavior that I see is that if the values in the column start with an uppercase, then then Match operator fails to find it no matter whether the match string starts upper or lower case.
>
>I was able to find any occurrence of a string by using the LIKE operator with the asterick wildcard around the string (instead of the match operator). Will this work for you?
>
>[Col1] like ''*Syncfu*''
>