I have a table:

cust_id character 10
name character 30

I want to print to text file:

cust_id only print first 6 characters
name only print first 25 characters

I tried either:

SELECT LEFT(cust_id,6),LEFT(name,25) FROM cust TO FILE CUSTDATA

or

USE cust 
LIST FIELDS LEFT(cust_id,6)+LEFT(name,25) TO FILE CUSTDATA OFF NOCONSOLE 

always has two spaces in front of the text:

  XXXXXXYYYYYYYYYYYYYYYYYY
  XXXXXXYYYYYYYYYYYYYYYYYY

while it should be no space ahead:

XXXXXXYYYYYYYYYYYYYYYYYY
XXXXXXYYYYYYYYYYYYYYYYYY

Please advise.

Thanks for the help.