Replace text in ntext variable

• Marius_privat

  Grasshopper

  Points: 15

  More actions

  May 19, 2003 at 3:27 pm

  #357774

  Hi - I've got a Stored Procedure that returns XML using the FOR XML EXPLICIT. One of the fields contain som characters that I need to replace, but the REPLACE() function doesn't handle ntext.

  Any input would be appreciated 🙂

  Best regards,

  Marius Christiansen

• ThomasH

  SSCertifiable

  Points: 7437

  More actions

  May 19, 2003 at 3:49 pm

  #457717

  Just looking at posts real quick... just off the top, look at BOL UPDATETEXT command.

  
  
  Once you understand the BITs, all the pieces come together