You can use a case expression like this:
WHEN '1' THEN 'January'
WHEN '2' THEN 'February'
END AS MonthName;Alternatively, if you want to make it hard for a non-SQL person to read and understand, you can do the following:
DATENAME(month,DATEADD(mm,CAST(@yourcol AS INT)-1,0))