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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2007-07-20 : 15:08:17
|
| Hi allWe have an NTEXT column in a table ETi am trying to replace tab, new line characters in the data select REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR(4000), ET.REASON), CHAR(10), '<LF>'), CHAR(13), '<CR>'), CHAR(9), ' ') "Internal Notes" from ETBut the max data in ET.Reason column is 4063 characters, so, able to replace only upto 4000 characters and remaining characters are being truncated.How can i make the replace function to affect all the data in ntext column having more than 4000 characters in it..Please help me on thisThanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-20 : 17:22:41
|
| Use UPDATETEXT method.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Urgent please..issue with NTEXT column