Hi!

Try to use some functions in the SELECT statement for VFP data, like INT and other that convert numeric to integer value. Or just convert data to string on the fly in the SELECT statement:

SELECT ltrim(STR(MyNumericField,12,0)) as MyNumericField, ...

This way you can pre-format any values before they returned by the SELECT statement.

HTH.

>Hi,
>
>VFP 6.0, Word97, MailMerge. String variables OK, but a numeric field without
>decimals shows up like this: 123.0 instead of 123
>
>Solution, other than duplicating the number as a string field in my DBF?
>
>Rolf