Never been to TextSnippets 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), '
') AS Expr1
FROM         OLD_NOTES
to tsql by codeguy on Fri May 12 18:00:40 +0000 2006

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


Related Posts