Pipe as field terminator in TSQL

[Tommymac501]

I have a SQL file that needs to be BCP exported to pipe delimited because of limitations on the recieving end.

I have tried the following with no sucess;

[BCP sql statement] + '.txt" -t"|", -c -T'
[BCP sql statement] + '.txt" -t\|, -c -T'
[BCP sql statement] + '.txt" -t^|, -c -T'

All of them produce the pipe as the delimiter, but, the pipes are also followed by comma's. Does anyone know a way to supress the comma?

[Tommymac501]

Solved it.. I didn't notice the Pipe was followed by a comma in my code..