title: How to add char type SqlParameter in SQL LIKE % %?
body: <p>Can't get this working, how to add a parameter in SQL LIKE % %  when its type is char?</p>
  
  <pre><code>SQL.Append("(Code LIKE @Code)");
  var sqlParameter = new SqlParameter("@Code",
                        System.Data.SqlDbType.Char, 
                        10,
                        System.Data.ParameterDirection.Input,
                        true, 
                        0, 
                        0, 
                        "Code", 
                        System.Data.DataRowVersion.Current, 
                        "'%300%'");    
  </code></pre>