>VFP3 has SERIOUS problems with integers. Since this is an SQL statement, change the SQLl to
>SELECT str(Myfield,n) as MyCHar, field2, field3.......
>This will give you character values which will prevent the original problem.

http://premium.microsoft.com/msdn/library/periodic/period96/D1/FT0896.htm

That's a reference to a FoxTalk article in MSDN Online that explains, with great clarity and detail, how to get around this problem. You may have to register first: the Online membership is free, unlike the ones where they send you hundreds of CDs....