August 28, 2003 at 9:35 am
Good day all,
I have a stored procedure that is currently taking a input variable of varchar(8000), and now I have the requirement that my stored procedure will have to take an input parameter of more than the maximum 8000 bytes or characters. I thought about making the input parameter of the text data type. However, I came to realize that the string functions charindex, left, right, len cannot be used on such a parameter. I know the substr, READTEXT, WRITETEXT, UPDATETEXT functions work with text data types. I thought the patindex function works with text data types but it does not. I need to find a way to parse through a text type string to search for a particular character namely '|' and then update the text type input parameter accordingly. Any help would be appreciated.
Patrick Quinn
August 28, 2003 at 6:10 pm
Have a look at Frank's reference at http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15691&FORUM_ID=9&CAT_ID=1&Topic_Title=ntext+confusion&Forum_Title=General
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply