Revision: 41323
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 16, 2011 08:20 by dotNetkow
Initial Code
SELECT Name
FROM People
WHERE Name in ('Bob', 'Mary', 'Joe')
ORDER BY
CASE Name
WHEN 'Mary' THEN 1
WHEN 'Joe' THEN 2
WHEN 'Bob' THEN 3
END
Initial URL
Initial Description
Similar to "FIND_IN_SET" from MySQL.
Initial Title
Specify order of rows returned in MS SQL Server
Initial Tags
sql, server
Initial Language
SQL