title: Match first character of a word in a String List with Linq
body: <p>I have one LINQ query. I am just beginner in Linq. I wanted to use it for autocomplete. I need to match the input with starting character of a word in a string. Consider the scenario.</p>
  
  <p><strong>List of String</strong></p>
  
  <pre><code>1. London Corporation
  2. Financial Services Industry
  3. European Union Countries.
  4. Derivative Securities
  </code></pre>
  
  <p>In the above list, When the user presses character 'C' then the query should return the value 1 and 3 as matching character 'C' in a string of words. If the Input is 'S' then, the result should be 2 and 4.</p>
  
  <p>I have tried the below one. But no idea about how can i proceed next. Please anyone tell me how can i split the word in a string and match for the input character. I tried the code below.</p>
  
  <p><strong>CODE</strong></p>
  
  <pre><code>    var model = (from line in db.BibContents
                  where line.TagNo == "020" &amp;&amp; line.Sfld == "a" &amp;&amp; line.Value.Split(' ').StartsWith(Val)
                      select new PoDetails
                      { 
                          BibId = line.BibId
                      }).ToList();
  </code></pre>
  
  <p>Thanks,</p>