Try:
COPY .. to .. delim with ""

>I have the below data in a table acct(5), location(15),label(5)and I want to create the txt file shown below. Do I use copy to output type sdf, delimited, delimited with ",", not having too much luck creating what I want.
>
>
>"output.txt" =
>811AD,SUDBURY ,B021193
>811AD,SUDBURY ,B020910
>811AD,SUDBURY ,B022401
>811AD,SUDBURY ,B023021
>811AD,SUDBURY ,B023207
>811AD,SUDBURY ,B024342
>811AD,SUDBURY ,B024341
>811AD,SUDBURY ,B024382
>811AD,SUDBURY ,B024351
>811AD,SUDBURY ,B024352
>811AD,SUDBURY ,B020809
>811AD,SUDBURY ,B021653
>811AD,SUDBURY ,B023958