title: Best (simple and efficient) way to query distinct tag list?
body: <p>There is a big Table -- <strong>Blog</strong> (assume records larger than 10 thousand), structure like:</p>
  
  <pre><code>Blog_ID  Title  Tag
  ----------------------
  1        AAA    T1|T2|T3
  2        BBB    T2|T4
  3        CCC    T3|T1|T2|T6|
  </code></pre>
  
  <p>..................</p>
  
  <p>Blog Tags are split with '|', and definitely COULD duplicate, I want to write a query to get all <strong>distinct</strong> Tags as well as <strong>Tag appearance</strong>, result like:</p>
  
  <pre><code>Tags   Appearance Count
  ------------------------
  T1     14
  T2     35
  T3     88
  T4     45
  </code></pre>
  
  <p>............</p>
  
  <p>Then what is the best (simple and efficient) way to achieve this please?  Once more limitation, SQL Server 2000 capability is highly preferred since my web app host provider is using SQL Server 2000.</p>
  
  <p><strong>Appreciate any help!!</strong></p>