sql server remove newline from string code example

Example: sql server remove enter from string

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')