SQL Server: Order by first characters, then rest of the string

Question

I need some help with a SQL Server query. The table has some kind of field like the following ones:

I'd want to sort them to look like this:

How can I solve this? Thanks in advance, regards.

Randy Minder · Accepted Answer · 2015-11-09 12:08:19Z

2

You don't give any details on data types and the characteristics of the data. However, based on what you did say, this should work. This will order the data on the first three characters of the column.

Select *
From MyTable
Order By Left(MyColumn,3)

answered Nov 9, 2015 at 12:08

Randy Minder

48.8k56 gold badges222 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

antonioalopezfernandez Over a year ago

Thank you so much, i can't believe it was so easy to do. May someone mark this answer as valid?

Collectives™ on Stack Overflow

SQL Server: Order by first characters, then rest of the string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related