Dim pQF as IQueryFilter
Set pQF = new QueryFilter
pQF.WhereClause = "upper(" & strFieldToSearch &") LIKE '%" & UCase(Replace(strSearch,"'","''")) & "%'"

queryFilter.WhereClause =  searchField + " LIKE '%" + search.Replace("'","''") + "%'";

queryFilter.WhereClause = strSearchField.ToUpper() + " LIKE " + "'%" + strSearch.ToUpper() + "%'";

queryFilter.WhereClause = "upper(" + strSearchField + ") LIKE'%" + strSearch.ToUpper() + "%'";