Control characters in tsql

Control characters in tsql

Char can be used to insert control characters into strings. The following table shows some common control characters.
Control Character Value
Char (9)
Linefeed char (10)
Carriage return character char (13)

Example:

Print   ' --------------------- '
Print   Char ( 9 ) + ' Hello '
Print   ' --------------------- '
Print   Char ( 10 ) + ' Hello '
Print   ' --------------------- '
Print   Char ( 13 ) + ' Hello '
Print   ' --------------------- '