Hi all,

I am trying to do sort on my below dataset from a field called "SchoolEmployees"

SchoolEmployees

Records1
Records2
Records3
...
...
...
DummyAdmin1
DummyAdmin2
...
...


So what I am trying to do is to have the value of DummyAdmin1 and DummyAdmin2 list at the very end of the records. Records1, Record2 and so on could be varies. The datatype if varchar and contains all of the school employee names but I want those two values (DummyAdmin1 and DummyAdmin2)always stay at the end of the result set (as the last two records). How can I achieve this sorting?

This result set is what I want to have:

SchoolEmployees

Records1
Records2
Records3
...
...
...
...
...
DummyAdmin1
DummyAdmin2

Thanks guys

Edited by CrystalGirl - 19 Apr 2016 at 4:05am