Use a terminator to mark the end of a column or row, separating one from the next. The default is no terminator.
Field terminators separate table columns.
A row terminator is a field terminator for the last field in the row of the table or file.
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.
Tabs, indicated by \t
New lines, indicated by \n
Carriage returns, indicated by \r
Backslash, indicated by \
Null terminators (no visible terminator), indicated by \0
Any printable character, for example, *, A, t, |
Strings of up to 10 printable characters, including some or all of the terminators listed above (for example, **\t**, end, !!!!!!!!!!, and \t--\n)