Edgar,

You cannot do it in one line because TO FILE doesn't support 'Type SDF' option and file created this way isn't SDF file but rather printout of the query result.

>Correct,
> I just want a SQL one liner - something like :::
>

>  Select contact, eligarea, groupnum, groupname, ;
>   WHERE NOT DELETED() ORDER BY IIF(LEFT(contact,1) = "A", "1", "2"), contact;
 INTO FILE c:\temp\vsamnew.txt Type SDF
>

>>I think he means he doesn't want the field cord included in the output file. He could just COPY TO FILE FIELDS EXCEPT cord.
>>