title: How to use REPLACE in Select Query? (SQL SERVER)
body: <p>Can I use REPLACE function conditionally?
  e.g. I have a query:</p>
  
  <pre><code>SELECT diag_type FROM DIAGNOSIS
  </code></pre>
  
  <p>It returns AXIS, AXISI, AXISII, AXIS-C, etc. I want if it returns a result that has AXIS, it makes it AXISIII. Can it be possible?</p>
  
  <p>Thanks in advance.</p>