title: Split a LINQ string list
body: <p>I believe this could be another easy one for you LINQ masters out there. </p>
  
  <p>I have a table with a field that consists of strings delimited by "#".  After I select the field using LINQ, how can I split each of the strings into a different list?
  My string list looks like:</p>
  
  <pre><code>#A#B#C#D#G#F
  </code></pre>
  
  <p>I used a simple LINQ query to access this:</p>
  
  <pre><code>from x in Special_texts
  where x.Name.Equals("ExceptionList")
  select x.Content
  </code></pre>
  
  <p>In the end, my list should contain:</p>
  
  <pre><code>A
  B
  C
  D
  G
  F
  </code></pre>
  
  <p>Thanks in advance.</p>