how to sort on text data type column ?

[King Shez]

HI Can any one let me know, how to sort on cloumn with text data type in SQL Server 2005, thanks in advance, kindly Reply ASAP.

[Blue_Boy]

select * from table order by columnname asc or select * from table order by columnname desc

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[King Shez]

you can not sort column with data type text with order by ASC or DESC, Even group by cann't be use, is there any other wat i can sort the column with the data type text. thankx for ur reply.

[Wendelius]

Have a look at SUBSTRING. I believe that you would have gotten far more answers if you wouldn't have requested to reply ASAP. That's considered rude.

The need to optimize rises from a bad design