Cetin

Having worked with your code it works fantastically well but the format of the results is causing me a problem. If I just supply say 2 columns all the results are nicely aligned.

ArticleNo             Supplier
------------------------------
001234                Neil
001345                Simon

But if I add another column then the 3rd column is not aligning properly

ArticleNo             Supplier              Quality
-----------------------------------------------------
001234                Neil                  LT2034
001345                Simon                     L54345
001289                Tony                    B1254

Im a bit confused why adding further columns gives me a format issue when working with 2 is fine.

Here is my code even trying to trim the fields:

SELECT crsmatch
PUBLIC lcbodyquery
set textmerge to memvar m.lcBodyquery noshow
set textmerge on
\
\<<PADR(LTRIM('ArticleNo'),20,' ')>>
\\<<PADR(LTRIM('Supplier'),40,' ')>> 
\\<<PADR(LTRIM('Supplier'),40,' ')>>
\------------------------------------------------------------------------------------
scan
\<<padr(LTRIM(crsmatch.articleno),20,' ')>>
\\<<PADR(LTRIM(crsmatch.descrip1),50,' ')>>
\\<<PADR(LTRIM(crsmatch.seamslippa),40,' ')>>
ENDSCAN