GilaMonster (2/8/2008)
Not directly, though you could convert the month number inot a date.SELECT DATENAME(month,'1900/' + CAST(monthNumber AS VARCHAR(2)) + '/01')
Heh, too much VARCHAR in that for me, Gail... 😛
SELECT DATENAME(mm,DATEADD(mm, MonthNumber-1,0))
--Jeff Moden
Change is inevitable... Change for the better is not.