title: Replace certain pattern in a long string in MS SQL using T-SQL
body: <p>I have a table in my MS SQL database where it has some incomplete data in a field.  This field in question is a varchar field and has about 1000 characters in the field.  This string consists of segmentations of words in the format of a forward slash followed by the segment and then ends with a forward slash (i.e. /p/).  Each of these segments would be separated by a space.  The problem is that certain of these segmentations do not have the last forward slash (i.e. /p).  I need to write a T-SQL script that would correct this problem.  </p>
  
  <p>I know I will need to use an update statement to do that.  I got the where clause too.  But the problem that I have is what am I setting it to equal to.  Since the string has about 1000 characters, I don't want to type the actual string and just correct the problematic segmentation.  My question is, is there a "RegEx replace function" that would only change problematic segmentations and leave the rest of the string alone?</p>
  
  <p>Your help will be greatly appreciated.</p>
  
  <p>Thanks in advance,
  Monte</p>