• USE [tempdb]

    GO

    IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[testmonths]') AND type in (N'U'))

    DROP TABLE [dbo].[testmonths]

    GO

    CREATE TABLE [dbo].[testmonths](

    [testMonth] [varchar](50) NULL

    ) ON [PRIMARY]

    GO

    INSERT INTO [dbo].[testmonths]([testMonth])

    SELECT N'May-11' UNION ALL

    SELECT N'May-12' UNION ALL

    SELECT N'May-13' UNION ALL

    SELECT N'Jun-12' UNION ALL

    SELECT N'Jul-12' UNION ALL

    SELECT N'Aug-13' UNION ALL

    SELECT N'Jun-11' UNION ALL

    SELECT N'Jul-11' UNION ALL

    SELECT N'Aug-11' UNION ALL

    SELECT N'Aug-12' UNION ALL

    SELECT N'Jun-13' UNION ALL

    SELECT N'Jul-13'

    SELECT testMonth

    FROM testmonths

    ORDER BY CONVERT( datetime , '01-' + testMonth );

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day