Filtering with Leading Space in the string

[G]

Hi,

I have used AllowFilteringByColumn in the radgrid and the normal filtering is working ok. Now, one of the column of the grid is FirstName and the data type is string and normal filtering is working. When a firstname contains Leading Space and the filter criteria is 'Equal To' then no result shows  but when the criteria is 'contains' then it shows result. I want to show the show the 'Equal To' criteria result also.
So, how to handle leading space in the filter criteria is 'Equal To'.
Pl, help.

Thanks,

G.Sen

[Viktor Tachev]

Hello,

You could add custom code that changes the FilterExpression of the RadGrid when the EqualTo filter is applied. Note, however that this would actually make the filter work incorrectly. The text entered in the input would not be equal to the actual data in the data source. More information on the different formats that are used for FilterExpression is available in this article.

This said, it is recommended to remove the leading spaces from the names that are stored in the data source. This way the filter functions would work as expected.

Regards,
Viktor Tachev
Telerik