Operand data type varchar is invalid for divide operator
<p>I've just started using SQL and I have a pretty basic question:</p>
<p>I'm tried dividing 2 columns (amount/rate) - I converted them from 'money' to 'INT' but when I tried executing it gave me this error:</p>
<blockquote>
<p>Operand data type varchar is invalid for divide operator.</p>
</blockquote>
<p>This is the query I typed:</p>
<pre><code>select referenceid, 
       CONVERT(decimal(15,3), sellamount) as 'amount', 
       CONVERT(decimal(15,3), rateactual) as 'Rate',
       CONVERT(decimal(15,3), 'amount' / 'rate') as 'local amount'
FROM currencyfxconversions
</code></pre>
<p>Can someone help me understand what I did wrong?</p>