replace function

• nathan_schmidt

  Grasshopper

  Points: 16

  More actions

  July 8, 2008 at 9:46 am

  #381521

  I am doing some data conversion and am trying to clean up some data. I have a problem with a comments field that had pipes (||) entered into it instead of exlamation points (!!). To solve this I was just going to run this:

  Update tbl_docket set comments=replace(comments,'|','!')

  I'm getting the following error:

  Server: Msg 512, Level 16, State 1, Procedure update_status_chg_date, Line 6

  Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used as an expression.

  The statement has been terminated

  What I find strange is I ran this code on a similar problem that effected multiple rows not long ago with no problems:

  update docfragment set filename = replace(filename, '!', ']')

• Kent Waldrop

  Hall of Fame

  Points: 3064

  More actions

  July 8, 2008 at 10:49 am

  #839646

  It looks to me like you might have a trigger that does not properly handle multi-record updates. Check and see if the table that is the target of the UPDATE statement has a trigger. If so, have look and see if the trigger has the name of the procedure object listed in your error message. If so, then review the trigger.

• nathan_schmidt

  Grasshopper

  Points: 16

  More actions

  July 8, 2008 at 12:35 pm

  #839725

  Thanks, You were right, I looked right past that part of the error message. They had a trigger that updated a status change column for any updated row.