TEXT/NTEXT Find and Replace

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Lowell » TEXT/NTEXT Find and Replace

TEXT/NTEXT Find and Replace

Rate Topic

Display Mode

Topic Options

Author

Message

Lowell

Posted Sunday, February 15, 2009 3:58 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

Comments posted to this topic are about the item TEXT/NTEXT Find and Replace

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #657414

tcshekar

Posted Friday, June 11, 2010 9:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 02, 2011 11:32 PM
Points: 4, Visits: 5

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.

Post #936134

Lowell

Posted Friday, June 11, 2010 11:03 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #936188