I always allow the user to perform case-insensitive searches on my sites, and while I know how to do this in the generated code, I wonder if there's a more concise way. For example I started with this:

filter.AddWithOr(PersonFields.LastName % likeValue);

When I realized I needed to specify case-insensitivity, I wound up writing this:

predicate = new FieldLikePredicate(PersonFields.LastName, likeValue);
predicate.CaseSensitiveCollation = true;
filter.AddWithOr(predicate);

Ideally I'd like a way to specify case-insensitivity using the short form -- I think it would make my code more readable. Plus I filter on a lot of fields.

I think that your are already doing it the best way possible. By the way I think the correct line would be:

predicate = new FieldLikePredicate(PersonFields.LastName, likeValue.ToUpper());

becasue the CaseSensitiveCollation property, when set to true, would use the UPPER() function equivalent in your db.

Cheers,

goose wrote:

I think that your are already doing it the best way possible.

OK. Perhaps I will request a feature in another section of the forum Or maybe roll my own...

goose wrote:

By the way I think the correct line would be

Thanks--I remembered that after I watched it fail the first time