I've got a Biography column in a Users table that holds the user's biography. This column could contain 1 sentence or 5 paragraphs of text.
I need a keyword search to search this biography column for the search word. I would like for the search to search each separate word in the biography and only search the first of the word. Example:
Biography: "My name is Bob and I was born in Kentucky."
Searching for "kent" WOULD match this biography because "kent" is contained in the first part of the word "Kentucky". Because the search will only search the FIRST part of each word, searching for "tucky" would not match any words in this biography.
What would the be the best way to design a linq query to accomplish this?
Thank you in advance.
Environment: C#.NET 4.0