Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-22 : 08:38:41
|
| Nick Cowley writes "HiI have a requirement to Strip the "Carriage returns" from an ntext column within a stored procedure.The results will be returned to a Web app.SQL2000 (latest SP)ANy help would be appreciated.CheersNick" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-22 : 08:40:20
|
| Hmmmm, ntext is going to make this tricky, as you can't use the Replace() function on such a column. You would have to break the column up into nvarchar(4000) sections and work on it that way, then write the contents back into ntext. Have a look in Books Online under READTEXT, WRITETEXT, and UPDATETEXT. |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-03-22 : 09:38:52
|
| Does this have to be handled in the Proc?Would be more easily handled in a middle tier/presentation tier. |
|
|
|
|
|
|
Stripping "Carriage return" from ntext column on select