Hi, I am trying to BCP out data from a particular table into a text file . But In one of the columns [varchar (390)] which is used to enter coments in the front end, there are sevaral rows which have carriage return. Since the default row delimiter is carriage return, the sql server is treating the fields after the carriage return as new rows. Is there a work around to this probelm ?? below is the BCP i am using. BCP databasename..tablename out c: ablename.txt -c -t"|" -r -Usa -Ppassword -S servername Any help highly appreciated.