ASC or DESC are the only options, but to get your desired results you might need to make a complex query.
can you show by example, what you need and also give us table details.

certainly someone will be happy to help you.

__________________
---------------------------
Errors = Improved Programming.
Portfolio