SQL - order by varchar columns

Question

I have a table containing a varchar column for months. Because of some reasons I have to save Persian months in it like Farvardin , Ordibehesh , ... . Now I want to select some rows from that table and I want to order my rows by months. what should I do ? Please just use SQL commands.

Answer 1

You need to create a custom sort order with:

SELECT *
FROM months
ORDER BY CASE
          WHEN monthName = 'Farvardin' THEN '1'
          WHEN monthName = 'Ordibehesh' THEN '2'
          ...
          ELSE monthName END ASC