CODEWITHSUNDEEP
sqlsql-serversql-order-by
user2535324
user2535324

Reputation: 11

How can I ORDER BY a column Text?

I'm trying to ORDER BY a column in SQL Server which is a TEXT type. How can I do that? I couldn't find in the internet..

Upvotes: 1

Views: 457

Answers (2)

sangram parmar
sangram parmar

Reputation: 8736

try this

   ORDER BY CONVERT(VARCHAR(50) ,ColumnName)

Upvotes: 0

RAS
RAS

Reputation: 3395

You can't. TEXT is deprecated. use VARCHAR(MAX)

Upvotes: 2

Related Questions