February 15, 2009 at 3:58 pm
Comments posted to this topic are about the item TEXT/NTEXT Find and Replace
Lowell
June 11, 2010 at 9:38 am
Got this error...on execution.
Msg 280, Level 16, State 0, Line 1
Only text, ntext, and image columns are valid with the TEXTPTR function.
June 11, 2010 at 11:03 am
tcshekar (6/11/2010)
Got this error...on execution.Msg 280, Level 16, State 0, Line 1
Only text, ntext, and image columns are valid with the TEXTPTR function.
sdounds like you are trying to use this against a varchar or varchar(max) column?
the regular REPLACE command works fine on varchar(max) columns, so there's no need for this procedure any more;
if you can post the definition of the table/column you are trying to find/replace, I can point out the issue.
Lowell
June 11, 2010 at 11:19 pm
The column is of TEXT data type.
June 11, 2010 at 11:25 pm
Yeah....I think you are right....Let me check a bit in detail and get back.
June 11, 2010 at 11:43 pm
It worked on the TEXT datatype. Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy