rowFilter compound expression problem

[barryr]

anyone got an idea why this won't work:

dataView1.RowFilter = "ID NOT IN(" + ErrorString + ") or " + "Description LIKE '%" + KeywordFilter2 + "%' or " + "Name '%" + KeywordFilter2 + "%' or " + "Place '%" + KeywordFilter2 + "%'";

this works fine:

dataView1.RowFilter = "ID NOT IN(" + ErrorString + ")"

as does this:

dataView1.RowFilter = "Description LIKE '%" + KeywordFilter2 + "%' or " + "Name '%" + KeywordFilter2 + "%' or " + "Place '%" + KeywordFilter2 + "%'";

but not together. Error string contains a string of type a,b,c.....

cheers
barry