Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TEXT/NTEXT Find and Replace Expand / Collapse
Author
Message
Posted Sunday, February 15, 2009 3:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:24 PM
Points: 12,921, Visits: 32,287
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
Posted Friday, June 11, 2010 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 2, 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
Posted Friday, June 11, 2010 11:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:24 PM
Points: 12,921, Visits: 32,287
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
Posted Friday, June 11, 2010 11:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 2, 2011 11:32 PM
Points: 4, Visits: 5
The column is of TEXT data type.
Post #936401
Posted Friday, June 11, 2010 11:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 2, 2011 11:32 PM
Points: 4, Visits: 5
Yeah....I think you are right....Let me check a bit in detail and get back.
Post #936402
Posted Friday, June 11, 2010 11:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 2, 2011 11:32 PM
Points: 4, Visits: 5
It worked on the TEXT datatype. Thanks
Post #936406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse