How do extend the use of Order by Clause 1

[craigscott]

Hello,

I have the following SQL Table

CREATE TABLE [dbo].[country_lookup] (
[country_id] [int] IDENTITY (1, 1) NOT NULL ,
[country_code] [varchar] (50) NULL ,
[country_name] [varchar] (50) NULL ,
[country_dialcode] [varchar] (50) NULL
) ON [PRIMARY]


I am trying to write a single query to order the results set so I can get a particular country_id First, then the rest ordered after it.

Something along the lines of:-

SELECT * FROM country_lookup ORDER BY country_id = 289, country_name

With no luck,


Any Ideas on a solution, situation requires not to use a Stored Procedure.

Cheers


Craig

 

[tlbroadbent]

Order By
Case
When Country_Id=289 Then 0
Else 1
End,
Country_Name Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[craigscott]

Your a Star,


That worked a treat.


Cheers


Craig