dimanche 24 mai 2015

How to sort the varchar datatype column in SQL server

I have a column in SQL Server that contains data,

1.1.1.QuestionText
1.1.1.Question
1.1.1(a).Questions
1.1.2.Questionswithtext
1.1.2(b).Text
10.1.1.Answers
2.1.1.Questions
2.2.2.QuestionText

etc...

How do I display this in Ascending order?

Aucun commentaire:

Enregistrer un commentaire