TEXT/NTEXT Find and Replace

Question

Post reply

TEXT/NTEXT Find and Replace

Lowell

SSC Guru

Points: 323504
More actions
February 15, 2009 at 3:58 pm

#383940

Comments posted to this topic are about the item TEXT/NTEXT Find and Replace
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

tcshekar SSC Enthusiast Points: 110 More actions · Answer 1

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.

Lowell SSC Guru Points: 323504 More actions · Answer 2

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!