SELECT ProductName FROM Products WHERE ProductScore > 100 ORDER BY CASE WHEN ProductScore = 125 THEN 0 ELSE 1 END, ProductScore
But this query won't use an index, so it would be a good idea to do this in two queries 2008/10/24 Tompkins Neil <[EMAIL PROTECTED]> > Hi > > I've the following basic query like > > SELECT ProductName FROM Products > WHERE ProductScore > 100 > ORDER BY ProductScore > > However, how can I order by ProductScore, but ensure the product with ID > 125 > is at the top ? Is this possible. > > Thanks > Neil > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/
