Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
order by character length=4 first, then the others
Thank you- fifiriri
- Post #3
- Forum: Microsoft SQL Server: Programming
-
order by character length=4 first, then the others
Hi all, I would like to order a query to have all 4 characters returns first (in descending order) then all the others 1 2 10 12 1000 1001 1002 ... 3123 3124 3125 890454 909844 945455 3125 3124 3123 ... 1002 1001 1000 1 2 10 12 890454 909844 945455 or 3125 3124 3123 ... 1002 1001 1000 945455...- fifiriri
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
