title: Replace multiple characters in SQL
body: <p>I have a problem where I want to replace characters</p>
  
  <p>I am using <code>replace</code> function but that is not giving desired output.</p>
  
  <p>Values of column table_value needs to replaced with their fill names like </p>
  
  <p>E - Email<br>
  P - Phone<br>
  M - Meeting</p>
  
  <p><img src="https://i.stack.imgur.com/0hjtN.jpg" alt="enter image description here"></p>
  
  <p>I am using this query</p>
  
  <pre><code>select table_value, 
         replace(replace(replace(table_value, 'M', 'MEETING'), 'E', 'EMAIL'), 'P', 'PHONE') required_value 
  from foobar
  </code></pre>
  
  <p>so second <code>required_value</code> row should be <code>EMAIL,PHONE,MEETING</code> and so on.</p>
  
  <p>What should I do so that required value is correct?</p>