Replace SQL Server new line with HTML

September 9, 2021 admin

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)

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.

Related Posts

More Stories

Top WordPress Themes

December 24, 2014 admin
safety of your blog

5 Quick Tips to Help Keep Your Blog Secure

July 17, 2014 admin
cloudflare CDN

Best Free CDN For WordPress

July 5, 2014 admin

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.

You may have missed

touch light wordpress theme mobile

15+ Top Mobile Themes For WordPress

December 4, 2021 admin
guru able angular 2 template web

17 Of The Best Rated Angular 2 Website Templates

November 28, 2021 admin
pogody website template angularjs

The 16 Best Responsive AngularJS Templates?

November 27, 2021 zeeshan

Replace SQL Server new line with HTML

September 9, 2021 admin
kids care children wordpress theme

Best WordPress Themes for Kids Website

August 17, 2020 admin