>If I do [SELECT ALLTRIM(STR(number)) TO FILE ascii.txt] I get leading blanks in the output for records where the length of the data is less than the maximum length. I need output data with no leading or trailing blanks. Any ideas?
>
>Bob

SELECT ALLTRIM(STR(number)) as dummy from table1 into cursor tmp nofilter
copy to ascii.txt type ....