拼SQL时候的除去无条件时加的判断的一种方法

            string[] sColumns = m_sKeyWords.Split(',');
            foreach (string sColumn in sColumns)
            {
                sFilter += sColumn + " like " + "'%" + sText + "%'"+" or ";
            }
            sFilter=sFilter.Trim().TrimEnd("or".ToCharArray());