This one is very quick and short method to get the month name in your desired formate while writing sql query.
SUBSTRING('JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ', (@YourMonthName * 4) - 3, 3) 
