code:
str.Replace("[", "[[").Replace("_", "[_").Replace("%", "[%").Replace("-", "[-").Replace("]", "[]").Replace("^", "[^");
sql:
where field LIKE '%' + @vcparameter + '%' ESCAPE '['
code:
str.Replace("[", "[[").Replace("_", "[_").Replace("%", "[%").Replace("-", "[-").Replace("]", "[]").Replace("^", "[^");
sql:
where field LIKE '%' + @vcparameter + '%' ESCAPE '['