title: Syntax error in sql caused by NULL data
body: <p>i have field data that consist of NULL. I try to get SUM data by making NULL data as 0.00.</p>
  
  <p>I use </p>
  
  <blockquote>
    <p>select Sum(cast(ISNULL (amount,0) as money)) from t</p>
  </blockquote>
  
  <p>here the <a href="http://www.sqlfiddle.com/#!6/b33e7/2" rel="nofollow">demo</a></p>
  
  <p>How to avoid this error
  "Cannot convert a char value to money. The char value has incorrect syntax"</p>