How do you test a column to see whether its sorted in ASC or DESC?

This question was originally asked by Vaibhav

Link to original question: QTP : How do you test a column weather it is sorted asc or desc in QTP ?