>>>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.
Then 'set heading off'
Cetin