Parameter Keyword case sensitive

[Philip]

I have created a paramater that allows the user to enter a keyword, and use a like statement to return the results. This works fine, however, the search appears to be case sensitive. Is there any way to make the parament non case sensitive?

=Fields.ModDescription    like     ="%" + Parameters.KWSearch.Value +"%"

The soultions I have seen on the forum suggest that I would need to use the TOUPPER in my parameter. I do not see how that would work on a word such as Cable, where only the first letter is capitalized.

[Peter]

Hello Philip,

For case insensitive filtering you have to apply the ToUpper() string function to both the Fields.ModDescription and Parameters.KWSearch.Value. As shown bellow:
= CStr(Fields.ModDescription).ToUpper()  Like  = "%" + CStr(Parameters.KWSearch.Value).ToUpper() +"%"

For more information check out the Filtering with string parameter that allows free user input blog article.

Kind regards,
Peter
the Telerik team