Deprecated. Don't use for new development and try to migrate existing uses.

Type: Scalar function

This function replaces all commonly used line terminating characters (or combination of characters) with a string supplied by the user.

Characters considered line terminators:

  • Carriage return followed by a line feed (CR+LF)
  • Carriage return (CR)
  • Line feed (LF)


@String mandatory nvarchar(max)
The string in which to replace line terminators
@Replacement mandatory nvarchar(max)
The string which replaces the line terminators