TEXT/NTEXT Find and Replace

  • Lowell

    SSC Guru

    Points: 323361

    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!

  • tcshekar

    SSC Enthusiast

    Points: 110

    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: 323361

    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!

  • tcshekar

    SSC Enthusiast

    Points: 110

    The column is of TEXT data type.

  • tcshekar

    SSC Enthusiast

    Points: 110

    Yeah....I think you are right....Let me check a bit in detail and get back.

  • tcshekar

    SSC Enthusiast

    Points: 110

    It worked on the TEXT datatype. Thanks

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

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