Hi Michael,
Try Padding the resultant field out to the required number of characters:
E.g.
SELECT PADR(ALLTRIM(salutation) + " " + ALLTRIM(firstname) ;
+ " " + ALLTRIM(lastname),92) AS fullname ;
FROM contacts
Where salutation is C(10), firstname is C(40), lastname is C(40) and catering for the 2 Spaces.
Hope this helps,
Gavin...
>I have a SQL statement which concatenates several fields and uses conditional IIF's to add formatting - but I find that VFP is truncating the results.
>
>I figure VFP takes the result of one result to calculate the width of the result table, and additional rows are just a lot longer than that.
>
>How can I get around this?
>
>TIA