>Hi All:
>
>I have a table with all fields character. How can I produce a text file where all the fields are separated by tabs, BUT I do not want the fields themselves delimited with a delimeter.
>
>So
>
>
>cat hat bat 1/3/2015
>
>
>NOT
>
>
>"cat" "hat" "bat" "1/3/2015"
>
>
>Thanks!
>
>Yossi
Try
COPY TO 'TabDelimitedFile.txt' DELIMITED WITH "" WITH CHARACTER TAB
If it's not broken, fix it until it is.
My Blog