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


SELECT REPLACE(REPLACE(address, char(13), '<br/>'), CHAR(10), '<br/>') FROM User


CHAR(10) = line feed (lf)

CHAR(13) = carriage return (cr)

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.