I'm having problem binding the data to the grid when I filter using the operator EndsWith.
In the database the values of the column have the Leading Spaces, and I had problem making iit work for IsEqualTo
also but I fixed it by padding leading spaces to the right of the input string. (as shown below)
But, I'm not sure how I should do it for the EndsWith Filter Operator.
I'm able to get the rows from the database by using where condition like '%ABC'.
But the rows are not binding to the grid.