Replace SQL Server new line with HTML

admin September 9, 2021 0

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

admin December 24, 2014 0
safety of your blog

5 Quick Tips to Help Keep Your Blog Secure

admin July 17, 2014 0
cloudflare CDN

Best Free CDN For WordPress

admin July 5, 2014 0

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

admin December 4, 2021 0
guru able angular 2 template web

17 Of The Best Rated Angular 2 Website Templates

admin November 28, 2021 1
pogody website template angularjs

The 16 Best Responsive AngularJS Templates?

zeeshan November 27, 2021 0

Replace SQL Server new line with HTML

admin September 9, 2021 0
kids care children wordpress theme

Best WordPress Themes for Kids Website

admin August 17, 2020 0