CREATE TABLE TAXTEMP (TXT VARCHAR(3000))

** Using CONVERT AND REPLICATE **

** Here is a sample to build EDI 810 file **

TXT = CONVERT(CHAR(2000),'DTL' + '|' +

REPLICATE(' ', 20 - DATALENGTH(RTRIM(A.FITEM)))...