title: Delete duplicate values from concatenated string
body: <p>I have the following table:</p>
  
  <pre><code>Object  Field  Values
  ------------------------------------
  1       1      A;A;A;B;A;A
  2       1      A;B;C;C
  2       2      X
  3       1      X;Y;Z
  3       2      V;V;V;V;V;V;V;V;V;V;V
  </code></pre>
  
  <p>How can I select from this table only the unique values from the concatenated <code>values</code>? So:</p>
  
  <pre><code>Object  Field  Values
  ---------------------
  1       1      A;B
  2       1      A;B;C
  2       2      X
  3       1      X;Y;Z
  3       2      V
  </code></pre>
  
  <p>In any scripting language, I would loop through the values from <code>Values</code>, explode on <code>;</code> and loop through that array with some logic filtering out duplicates. However, I need to do this only using SQL (Server 2008).</p>
  
  <p>Can anybody tell me if and how this can be done?</p>
  
  <p>Any help is greatly appreciated :-)</p>