title: How do I get distinct characters of string column in mssql?
body: <p>Given:</p>
  
  <pre><code> | name
  -+---------------------------
   | Josef Knoller
   | Josef Somos
   | KFZ Wiesauer
  </code></pre>
  
  <p>wanted result:</p>
  
  <pre><code>JOSEFKNMLRZWIAU
  </code></pre>
  
  <p>(case in the result does not matter - it was just easier holding the UPPER key while writing)</p>
  
  <p>Is there any way to do this in <code>T-SQL</code>?</p>
  
  <hr>
  
  <p>sorry ... i've mixed column and row ...
  it's 1 column and n rows</p>
  
  <p><code>MLRZWIAU</code></p>
  
  <ul>
  <li>M comes from <code>Somos</code></li>
  <li>L comes from <code>Knoller</code></li>
  <li>R comes from <code>Knoller</code></li>
  <li>...</li>
  </ul>
  
  <p>clearer?</p>