I am facing a small issue while sorting the gird.
I have a column which contains some strings, few of them are just empty strings ie. "".
Example data is:
OCLU 123123-2*OCLU 123123-2
The problem is that whenever i click on header of this column the grid gets sorted but it does not sorts as expected.
It should sort in the order of A-Z but it gives me a random sort, a few "A" strings are at top, then a couple of "B","C","D" and so on strings.
and again randomly i get "A", "B"... strings at the bottom.
Can anyone suggest what might be causing this.