>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?
>

What happens if you copy the data to a cursor using VarChar instead of Char?

Tamar