How sort DataView so blanks are at bottom, not top?

  • Thread starter Thread starter Ronald S. Cook
  • Start date Start date
R

Ronald S. Cook

I have a DataTable with column "Sequence". Values are like:

Sequence
--------
5
1
3
(blank/null)
7
6
(blank/null)
4


When I create a DataView and do a sort, I get

Sequence
--------
(blank/null)
(blank/null)
1
2
3
4
5
6
7

But I need the blank/nulls to be at the end like

Sequence
--------
1
2
3
4
5
6
7
(blank/null)
(blank/null)


How can I do this, please?

Thanks,
Ron
 
Ronald,

The only thing I can think about what uses a short answer is:
Add an extra column with the contents of your column
Replace in that column all spaces by ZZZZZZ (or any other high value)
Use that as the sort item.

Cor
 
Back
Top