title: Update query returns wrong values
body: <p>I have this function:</p>
  
  <pre><code> virtual public bool EditVideoNumber(String oldnumber, String channelnumber)
      {
          using (var con = GetConnection())
          {
              con.Open();
              var cmd = new SqlCommand();
              cmd.Connection = con;
              cmd.CommandText += "update Videos set number=REPLACE(number,@oldnumber,@channelnumber)";
              cmd.Parameters.Add(new SqlParameter("@channelnumber", channelnumber));
              cmd.Parameters.Add(new SqlParameter("@oldnumber", oldnumber));
              try
              {
                  cmd.ExecuteScalar();
                  return true;
              }
              catch (Exception e)
              {
                  return false;
              }
          }
      }
  </code></pre>
  
  <p>The problem is that, in the moment that i update the value oldnumber, from 102 to 1020 (just an example), it returns as a value 10200. i have tried to change the query several times, but nothing seems to make it work</p>