Posted onFebruary 9, 2011 by Josephine month number to month name CONVERT(varchar(3), date_field, 100)