In building a Select-SQL statement, I need the Order By to actaully be ordered by the Month and then Day of a date field similar to:

Order By MONTH(MyTable.HiredDate), DAY(MyTable.HiredDate)

Anyone know how to do something like this?

I would prefer not to have to create a temp index to do this.

Thanks,
Mel Cummings