title: How to update text using "regular expressions" in SQL Server?
body: <p>In a column in a SQL Server database table, the value has a format of <code>X=****;Y=****;Z=5****</code>, where the asterisks represent strings of any lengths and of any values. What I need to do is to change that 5 to a 4 and keep the rest of the string unchanged.</p>
  
  <p>Is there a way to use something like regular expressions to achieve what I want to do?  If not using regular expressions, can it be done at all?</p>