Replace SQL Server new line with HTML
Useful for displaying on HTML when using SQL Server as database

For SQL Server
In order to replace \r\n with <BR/> tag from address field saved in the database, we can use following
T-SQL.
SELECT REPLACE(REPLACE(address, char(13), '<br/>'), CHAR(10), '<br/>') FROM User
Where
CHAR(10) = line feed (lf)
CHAR(13) = carriage return (cr)