>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
Use the PADR() function within your IIF().
Chris McCandless
Red Sky Software