An SQL-SELECT statement sets the field widths for the result by evaluating the first row of the result set. If that returned "May" then you would have a 3 character wide field.
You could use PADL() or PADR() around the CMONTH() function to return a string of fixed length so that the result column is always long enough.