Sorting of "Text" Datatype

Question

"Select *, SUBSTRING((SELECT ',' + s.product FROM DiscountedWarrantiesOffersProducts s where idoffer=d.id ORDER BY s.product FOR XML PATH('')),2,200000) as products from DiscountedWarrantiesOffers d"

 

This is the query from  I am getting the Data on Gridview.

I want to sort the fields in that gridview.

One field is Text datatype.

 

Kindly suggest the query.

 Akash