Searching for records using RowFilter

[Amit Anand via .NET 247]

Hi All

I have a Data Table which has records like this

Name Descr Items
1 decr1 a,b,c
2 descr2 a,b
3 descrx a
4 descr4 b,c


Now I want to search for all those records which have a in the column Items
so my search should return Name 1,2 and 3
I tried using RowFilter with an IN clause but it somehow does not work.
If someone could provide mw with a sample it would be of gr8 help.

Thanks

 

[Miha Markic [MVP C#]]

Amit,

If items in Items column are all single letter, then you might use
Items LIKE '%a%'