title: Replace whole word using ms sql server "replace"
body: <pre><code>declare @str varchar(50)='GoodLuck Markand'
  declare @replacedString varchar(50)
  set @replacedString = replace(@str,'Good','Better')
  print @replacedString
  </code></pre>
  
  <p>I want the output to be unchanged, because there is no single word like 'Good'.
  But the output is 'BetterLuck Markand'.</p>
  
  <p>I want the MS SQL Replace function to Compare the exact word and then replace it.
  How can i do so?</p>