Thanks Leo, that is exactly what I want, just had to create a temp file with fields required separated by commas first...

SELECT PADR(f1,8)+","+PADR(f2,20) AS data FROM sourcefle WHERE NOT DELETED() INTO CURSOR tmpexport
SELECT tmpexport
COPY TO textfle DELIMITED WITH SDF

Hooray