I'm getting the name of the month with the following code in a select-sql from a table with totals for products shipped per day:

select distinct val(substr(shipdate,1,2)) as month_num,cmonth(ctod(shipdate)) as month

The field in the resulting table seems to be limited to the size of the first entry i.e. fieldsize = len(January). So all I get for the next month is Februar.

Is there any way to stop this from happening?


TIA

E.R. Gilmore