InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:34:13 GMT20http://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxIf those 2 columns are in a table, then[code="sql"]SELECT name FROM SomeTable ORDER BY sortorder[/code]No CTE requiredMon, 10 Dec 2012 05:44:45 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxwrap in a cte then just select the one columnMon, 10 Dec 2012 05:39:45 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxHi anthonyIs it Possible to get only single column name.name sortorderSmith 1Jack 2David 3Ellen 4john 5Peter 6sortorder column is not requiredMon, 10 Dec 2012 05:35:18 GMTMinnuhttp://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxThaaaanks anthonyGreat.....!Mon, 10 Dec 2012 05:30:56 GMTMinnuhttp://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxIf you have some way of telling SQL the sort order then yes[code="sql"]declare @table table (name varchar(10))insert into @table values ('Smith'),('Jack'),('David'),('Ellen'),('john'),('Peter')select * from @table order by name ascselect * from @table order by name descselect *, case name when 'Smith' then 1 when 'jack' then 2 when 'david' then 3 when 'ellen' then 4 when 'john' then 5 when 'peter' then 6 end as sortorder from @table order by sortorder[/code]Mon, 10 Dec 2012 05:09:52 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1394554-391-1.aspxHi Team,Is it possible to sort records in custom.Eg:i've below records in a table.johnPetersmithEllenJackDavidi want in below order Smith Jack David Ellen john PeterMon, 10 Dec 2012 05:04:30 GMTMinnu