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