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-01-21 : 08:45:13
|
| Mike writes "Need to locate and update a string in a long text field. I tried using patindex and charindex but it returns 0, even though the field contains the string. The functions don't seem to locate anything over 255 characters deep.. The datalength of the field is 17726" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-21 : 11:18:41
|
| What's your TEXTSIZE set to?Brett8-) |
 |
|
|
|
|
|
Locate a string in a long text field