Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Replace text in a TEXT type data column (See related posts)

// Replace text in a TEXT type data column

SELECT     REPLACE(SUBSTRING(Note, 1, DATALENGTH(Note)), CHAR(13), '<BR>') AS Expr1
FROM         OLD_NOTES
to tsql by codeguy on Fri May 12 18:00:40 +0000 2006

Comments on this post

MikeB1234 posts on Jan 05, 2009 at 19:06
This was excellent. It worked for me, and was so much simpler than the other solutions I ran across.

You need to create an account or log in to post comments to this site.


Related Posts