using System; public class Class1 { public Class1() { public static string GetSelect(list listNames) { string sqlText = "select * from Persons where 1=1"; if (listNames.count > 0) { int count = 0; string addWhere = "AND ("; foreach (string name in listNames) { if (count > 0) { addWhere += "AND "; } addWhere += " Field like '%" + name + "%'"; count++; } addWhere += ")"; } } } }