ORDER BY where the order is contained in a string

Order by requires the column names not the column values. You may be able to achieve it using dynamic SQL. But it does not look logical to me. You may be able to do such sorting better in application code than DB side.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.