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?