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