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