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)
Parameters
@String
mandatory
nvarchar(max)
The string in which to replace line terminators
@Replacement
mandatory
nvarchar(max)
The string which replaces the line terminators