SELECT *
FROM tblCountry
WHERE Country_Id = 26
UNION ALL
SELECT *
FROM tblCountry
WHERE Country_Id <> 26

--order by country_Name

i need to select country_id =26 and then the rest i want them ordered by
name.
if i put order by country_name, the country_id 26 isn't displayed as the
first one.
is there anyway to apply the order by only to the second select not the
whole?

*** Sent via Developersdex http://www.developersdex.com ***