title: The conversion of nvarchar value "0854697543" overflowed an int column in select command
body: <p>I have a select command, and it returns answer records, but it also gives an error in  Visual Studio 2010's query builder with this query:</p>
  
  <pre><code>SELECT  *
  FROM    Orders
  WHERE   (BCode = 025) AND (Date BETWEEN '1390%' AND '1391%') OR
          (Date BETWEEN '1390%' AND '1391%') AND (MCode = 0123456789)
  </code></pre>
  
  <p>The error is:</p>
  
  <blockquote>
    <p>Error Message: the conversion of nvarchar value "0854697543"<br>
    overflowed an int column</p>
  </blockquote>
  
  <p>Data types are </p>
  
  <pre><code>BCode : nvarchar(50)
  Date :  nvarchar(50)
  MCode : nvarchar(10)
  </code></pre>
  
  <p>Where is the problem?</p>