expression field bug?

[Heath Brand]

I may have found a bug in the expression field match operator (or perhaps I''m just don''t understand how it should work). When I create a new expression field to find all columns that contain a particular string, it only works if the string I''m using to search doesn''t start from the beginning of the string I''m searching for. e.g.

[CompanyName] match ''Sync'' - doesn''t find it
[CompanyName] match ''fusion'' - does find it.

It looks like it''s skips the first character when doing the search.

Heath

[Administrator]

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*''

[Administrator]

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*''
>