Is the following possible: Retrieve all last name that starts with a p using LINQ. But the first name and last name is one word separated by a space.
Example would be Jonh Peter. Luke Sam, Rock Papers,Lee P
I tried the following:
var result = test.Where(x => x.Owner.Split(' ')
var result = test.Where(x => x.IndexOf(" P", StringComparison.OrdinalIgnoreCase) > 0);