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 - 2005-05-25 : 07:40:53
|
| Ganesan writes "Hi, I am using the text datatype as a parameter to my stored procedure.In that stored procedure i am using string manipulation with that parameter.I can't assign the delimitted string to the text datatype parameter.this is my problem.Pls tell me solution..ThanksB.Ganesan" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-25 : 07:42:58
|
| Do not use text if you need to manipulate it afterwards. Use varchar(8000) variables instead, several of them if you have to.The only way to manipulate a text value is to insert it into a text column in a table and then use WRITETEXT or UPDATETEXT to change it. See Books Online for more details. Even if that works for you, you cannot put the result back into a text variable, you'd have to just SELECT it from the table. |
 |
|
|
|
|
|
Text datatype problem in sql server 2000