I completely agree with you, but in this case, the sort order will not be changeable by the user (ever), and there will only ever be one sort order. If...

Thanks, I actually do have such a table (it translates status id to name and description), so its pretty easy to just add another column with the sort order. Thanks...

Thanks, that looks great. However, the number can become 2 decimal places, so I thought something like:

select ('S'+CAST ([statusId] AS VARCHAR(255))) as sid from tbl_xenix

order by CHARINDEX(sid,'S5S4')

but it says 'sid'...

So which ones are you stuck on? Just 7 and 8?

I don't see why you need to use OR, just AND...

Surely something like:

SELECT * from table

WHERE NOT (clinic_spec...