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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 how to use text datatype in a sp

Author  Topic 

00kevin
Yak Posting Veteran

78 Posts

Posted - 2006-08-17 : 11:47:59
How do you make use of a table that contains a text field and execute a find and replace on it.

varchar(8000) isn't large enough to hold all the text I need to parse.

I also need to be able to pass the results to stored procedure that has a text datatype as a parameter.

thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-08-17 : 11:51:58
http://www.nigelrivett.net/SQLTsql/InsertTextData.html
http://www.nigelrivett.net/SQLTsql/ReplaceText.html
http://www.nigelrivett.net/SQLTsql/ReplaceText2.html



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

00kevin
Yak Posting Veteran

78 Posts

Posted - 2006-08-17 : 14:31:21
thanks !
Go to Top of Page
   

- Advertisement -