Home Forums SQL Server 2008 SQL Server 2008 - General How to order by month which is varchar field according to date format? RE: How to order by month which is varchar field according to date format?

  • August 7, 2012 at 6:45 am

    #1522540

    You can add another column 'YearMonth' in which u should store values like '201201','201202'....

    If u do this, u can sort month field easily