BCP Field Separator

Hi All,
I am trying to use bcp with Field Separator as |. Now, | is the bitwise Or o
perator. The bcp is giving error if I sepcify -t | .
Please suggest something as I have to upload a file separated with pipe.
DipankarHi
Use -t "|" (Inside double quotes)
Thanks
Hari
MCDBA
"Dipankar Ganguly" <dipankarganguly@.hotmail.com> wrote in message
news:EF3D99FB-31F9-42D7-B920-BCEF1EB52541@.microsoft.com...
> Hi All,
> I am trying to use bcp with Field Separator as |. Now, | is the bitwise Or
operator. The bcp is giving error if I sepcify -t | .
> Please suggest something as I have to upload a file separated with pipe.
> Dipankar|||Dipankar,
put double quotes around the delimiter. i.e.
bcp mydb..mytable out C:\mytable.bcp -c -T -t"|"
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Thanks all...It's working perfectly now.