title: SQL Server CE Cast/Convert Double to String
body: <p>This may seems like a stupid question for most, but it has been bugging me for quite a while.</p>
  
  <p>How do we concat a string and an integer in SQL Server CE?</p>
  
  <p>FYI, I am using Vb.Net and Visual Studio 2010 Query Builder.</p>
  
  <p>I tried </p>
  
  <pre><code>SELECT CONVERT(VARCHAR(10), mi.qty) FROM MutationItem mi
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT CAST(qty AS VARCHAR(10)) AS Expr1 FROM MutationItem mi
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT CAST(qty AS VARCHAR) AS Expr1 FROM MutationItem mi
  </code></pre>
  
  <p>with no luck. </p>
  
  <p>The latter gives me an error : </p>
  
  <blockquote>
    <p>Error in list of function arguments: 'AS' not recognized. Unable to
    parse query text.</p>
  </blockquote>
  
  <p>Please give me a hand on this.</p>
  
  <p>Thanks !</p>