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 |
|
gpc44
Starting Member
35 Posts |
 Posted - 2011-08-10 : 12:00:50
|
Hello,i have a Problem with substring. I have to search in a html-code. This string is stored into a NVARCHAR(Max) variable and sometimes is greater then 5000 Bytes. Substring returns NULL or an Error if the String is to long. Is there a way to avoid this Problem? Is there a Limit with substing???ThanksNicole  |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-08-10 : 12:41:14
|
| Not sure what you are doing, but SUBSTRING works just fine with (n)varchar(max). Is it possible you are using CHARINDEX or something to search for a particular character or string and it is not found, thereby passing an invalid paramter to the substring function? |
 |
|
|
|
|
|
Substring To long