SQL like 语句特殊字符 替换 kiddy

   /// <summary>
    /// SQL like 语句特殊字符 替换
    /// </summary>
    /// <returns></returns>
    public static string SQLStrReplace(string str)
    {
        String RetuenValue = "";
        if (str.Trim() != "")
        {
            RetuenValue = str.Replace("[", "[[]").Replace("'", "''").Replace("^", "[^]").Replace("--", "[--]").Replace("_", "[_]").Replace("%", "[%]").Replace(@"\", "\\\\");
        }
        return RetuenValue;
    }