SQL Server Performance

Using Control Characters as delimiters in BCP

Discussion in 'SQL Server 2005 General Developer Questions' started by prasanna81, May 12, 2008.

  1. prasanna81 New Member

    Hi,
    Is it possible to use the control characters(such as ^_ the decimal value is 31) as the delimiter in the bcp command.
    If yes please let me know how we can use that.
    Thanks,
    Prasanna
  2. satya Moderator

    I don't see any recommendation or statement that you cannot use it, in general the common ones are :
    CHAR can be used to insert control characters into character strings. The following table shows some frequently used control characters.
    Control character Value
    Tabchar(9)
    Line feedchar(10)
    Carriage returnchar(13)

Share This Page