Home Forums Article Discussions Article Discussions by Author Discuss content posted by Lowell TEXT/NTEXT Find and Replace RE: TEXT/NTEXT Find and Replace

  • June 11, 2010 at 11:03 am

    #1179327

    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!