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

For SQL Server
SELECT REPLACE(REPLACE(address, char(13), '<br/>'), CHAR(10), '<br/>')
Where
CHAR(10) = line feed (lf)
CHAR(13) = carriage return (cr)