>>Hi everybody,
>>
>>I have this problem, which I'm seeking the best solution. I want to extract ~2mln. records from database into SDF file. I can do it in one SQL, but it produces first line with Field names. I don't want them. What's the best way to get rid on field names? Do I need to go SQL into table then copy to file?
>
>What's wrong with copy to .. SDF ?
>Cetin

Oops again, would not work. In our database we have address field and we don't have busres field. Customer wants StNum, Street fields and BusRes field.
So, I have to create SQL like this:

select lastname, firstname, padr(substr(Address,1,at(' ',Address)),6) as StNum, ;
padr(ltrim(substr(Address,at(' ',Address))),25) as Street, State, ;
Zip, Phone, 'R' as BusRes

So I think I have to use two steps here. It would be easier, though job would run quite long... It's one in year job, so that's not a big deal.

Thanks again.