asp.net模糊搜索

if (!string.IsNullOrEmpty(COURSEWARE_NAME.Text))        {            char[] c = COURSEWARE_NAME.Text.ToCharArray();            string nameconditiob = "";            for (int i = 0; i < c.Length; i++)            {                if (i == 0)                {                    br.AppendFormat("and COURSEWARE_NAME like '%{0}%'", c[i].ToString());                }                else                {                    br.AppendFormat("and COURSEWARE_NAME like '%{0}%'", c[i].ToString());                }            }        }