Order by specific word, then alphabetically

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Order by specific word, then alphabetically

Order by specific word, then alphabetically

Rate Topic

Display Mode

Topic Options

Author

Message

barcode-405082

Posted Monday, October 19, 2009 3:57 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 26, 2009 1:22 PM
Points: 20, Visits: 34

I have a lot of parameters in a table. I query the database to popuplate dropdown boxes with specific options. Some dropdowns have an option "OTHER". How do I query the database to return "OTHER" as the first option, and then sort alphabetically? eg:

Select your gender:
OTHER
MALE
FEMALE

Right now I only know how to order asc or desc or as the data was entered by ordering by the ID. Is there a way of doing what I want to do? I'm using SQL 2008 Enterprise.

Post #805311

Garadin

Posted Monday, October 19, 2009 5:01 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 4:08 PM
Points: 1,525, Visits: 4,047

Something like this:

ORDER BY CASE WHEN Col='Other' THEN 1 ELSE 2 END, Col

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. Wink

Links: How to Post Sample Data :: Running Totals :: Tally Table :: Cross Tabs/Pivots :: String Concatenation

Post #805328

barcode-405082

Posted Tuesday, October 20, 2009 9:09 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 26, 2009 1:22 PM
Points: 20, Visits: 34

Thank you! Worked like a charm!

Post #805806

« Prev Topic | Next Topic »

Permissions