order by case type
when 'z' then 0
when 'e' then 1
when '3' then 2
else 9 end
-- Prepare sample data
DECLARE @Untouchable TABLE (ID INT, [Month] VARCHAR(13))
INSERT @Untouchable
SELECT 4, 'March' UNION ALL
SELECT 3, 'April' UNION ALL
SELECT 1, 'February' UNION ALL
SELECT 5, 'January' UNION ALL
SELECT 2, 'May'
-- Do the magic
SELECT ID,
[Month]
FROM @Untouchable
ORDER BY CAST([Month] + ' 2007' AS DATETIME)
ไม่มีความคิดเห็น:
แสดงความคิดเห็น