title: Error Encountered with AS
body: <p>I got issue on this query kindly assist. i was trying to change the null value to 0 but when I try to run this query it encountered syntax error with AS : </p>
  
  <pre><code>select CAST(COALESCE(STATUS AS NVARCHAR(5))) from dbo.amb_cancel_master
  </code></pre>