my client requests to print the data to txt file.

the data is:

Inventory_partnumber
01001
01002

I tried:

COPY TO output1 TYPE SDF

I got:

Inventory_partnumber => total 20 characters
01001                => with extra 15 space
01002                => with extra 15 space

if I used:

COPY TO output1 DELIMITED WITH ''

I got:

'Inventory_partnumber' 
'01001'                            
'01002'                             

while my client requests it has to be no extra space after the value, and no '

is there anyway to do it?

thanks for the help

Regards,

Jerry