0

Please see this example

SELECT *
FROM Item WHERE (PartNumber LIKE 'KEA 12201 N%')

Result = 0 rows

SELECT *
FROM Item WHERE (PartNumber LIKE 'KEA%12201%N%')

Result = matching rows

Here space will replace with any character .then it will show the result

same thing I need to do in linq with lamda expression

ex:- List.where(u => u.PartNumber.StartsWith(partNumber))

but this will show no result while space contain search word

Please help me.

Saiful haque.k
  • 1
  • Why to use LINQ in a first place, it's probably better to use Regular Expression. Here is answer on similar question - https://stackoverflow.com/questions/1040380/wildcard-search-for-linq – Dionis Takac Jun 21 '21 at 15:51

0 Answers0