Yes, there is a problem. If you run select cmonth(somedate)... , you cannot know what will be the size of the field, and so if the first cmonth encountered by vfp was 4 chars wide, that will be the size of all your column ( if the first month is June for instance ). The best way is to use a fixed length in the result of your sql column, something like :

select left(cmonth(SomeDate),10) as MyMonthName, etc...
This is particularly critical in views, where in your case you could get an error everytime you make a requery...

HTH
Jaime


>Yes, there is problem with SQL?

Why do programs stop working correctly as soon as you leave the Fox?