bcp copy using special characters

I am doing bcp export from sql server table to text file. But I am facing problem.Data in table contains special characters sucha as tab, spaces. So when I am exporting the data to text file, it generates extra space or tab in output. So is there any way so that I can eliminate the space or tab in sql server table during bul copy. Can anyone help me?

Instead of exporting table you can export result of a query. The query can use RTRIM on columns with blank spaces so that it does not appear in the export file.

Quote:

---

Originally Posted by skhanal

Instead of exporting table you can export result of a query. The query can use RTRIM on columns with blank spaces so that it does not appear in the export file.

---

Thank you. But is there any way to detect too many tabs in bcp export.