I have a grid with few columns i wanna sort on. There's a column e.g. called 'Users country' where the value can be NULL and the field remains empty. The live grid manages dozens of thousands of rows which is fine but the ascending sorting on this column shows me all the rows where the country is NULL at first and somewhere later there appears the first row with AD (Andorra), AE (UAE) etc. The problem is to find this first row in a large grid.
So the question is: is there a way to skip rows where the current sort field is NULL and simple jump to the first row where it isn't?
Thanks for help in advance,