Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kartik M Kumar Month Name RE: Month Name

  • February 21, 2011 at 7:53 am

    #1289431

    Function MonthNamex(@mm numeric (2))

    as

    select case when @mm not between 1 and 12 then 'Invalid Month' else datename(mm,str(@mm)+'/04/2011') end