title: Return Original List using Substring in LINQ
body: <p>I have the following data</p>
  
  <pre><code>ItemId | ItemName | ItemBy | ItemCreatedOn
    1    | A100     |  User1 |  2016-10-04
    2    | A200     |  User1 |  2016-10-04
    3    | A300     |  User1 |  2016-10-04
    4    | A400     |  User1 |  2016-10-04
    5    | A600     |  User1 |  2016-10-04
    6    | D100     |  User1 |  2016-10-04
    7    | D900     |  User1 |  2016-10-04
    8    | D200     |  User1 |  2016-10-04
    9    | D300     |  User1 |  2016-10-04
  </code></pre>
  
  <p>This is what I want to return:</p>
  
  <pre><code> ItemId | ItemName | ItemBy | ItemCreatedOn
    5     | A600   |  User1 |  2016-10-04
  </code></pre>
  
  <p>My approach</p>
  
  <p>Get all the list of items starting with A</p>
  
  <pre><code>var allItems = db.Items.Where(x.ItemName[0] == itemName[0]).ToList();
  </code></pre>
  
  <p>use substring </p>
  
  <pre><code>var items = allItems.Select(x =&gt; x.Substring(1));
  </code></pre>
  
  <p>The above returns a list of string, but I want to return a list of all the items without A so that I can use <code>Max()</code> on <code>ItemName</code> to get the record I need</p>
  
  <p>How can I return the list of objects and then use Max correctly?</p>