Try

COPY TO whatever.txt DELIMITED WITH "" WITH CHARACTER ";"

>
>I try to create an output file that uses semicolon as delimiter instead of comma.
>
>So the output must be
>

>00001;Test;Etc
>00002;Test2;etc
>

>Everyting I try with the Copy To command does not produce the desired result. I hoped to be able to do this without creating the text file line by line, but what is correct syntax?