>>>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 ....
>
>Bob (via Ed)
>
>Be very careful with a SQL-SELECT field of variable length. They default to the length of the FIRST record, so some data may be truncated. I ran into this with an ALLTRIM(name). The system worked fine on my test data (first name 'Christophersen') and failed on the live data (first name 'NG') :-)
>
>Barbara
Yes Barbara good point. I always hated to add something like padr() to recover it.
Cetin