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());
                }

            }
        }