hi Hugo,

million thanks, it works perfectly

Jerry



>Char or VarChar will NOT make a difference, you need to use delimited with with character, I think this will give you what you want:
>
>

>COPY TO output1 delimited with "" with character ',' && the first one should be double quotes, not single quotes, the second one, for the comma, can be either (or you can take it out)
>

>
>[Update]
>Not sure my comment was clear, what I meant is that you can take out the last with character
>

>COPY TO output1 delimited with "" 
>

>
>will give you the default comma as a separator, but it should be double quotes.
>
>
>>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