title: Convert Varchar To Money
body: <p>I am trying to convert a <code>varchar</code> column to money but I keep getting this error</p>
  
  <blockquote>
    <p>Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to run this query.</p>
  </blockquote>
  
  <p>Am I not using the convert function like the error suggests?</p>
  
  <pre><code>Select
      tellerID,
      SUM(CASE 
             WHEN CONVERT(money, value1) IS NULL THEN '0' 
             ELSE CONVERT(money, value1) 
          END) AS [Total Value 1]
  From 
      intakedrawer
  Group By 
      tellerID
  Order By 
      tellerID
  </code></pre>