Field and Row Terminators

Use a terminator to mark the end of a column or row, separating one from the next. The default is no terminator.

Terminators are very useful for dealing with character data because you can choose human-readable terminators. The bcp character option, which uses tabs between each column with a newline terminator at the end of each row, is an example of using terminators that enhance the readability of a data file.

Supply your own terminators when you prepare data for use with other programs, and you want to use bcp to prepare tabular data. The available terminators are:
Note: Control characters (ASCII 0–25) cannot be printed.