title: Convert negative prediction output to zero in azure machine learning
body: <p>In azure machine learning experiment, i am getting negative predictions. i want to replace my all negative prediction with zero. I do not have programming skills so i am using SQL transformation.</p>
  
  <p>after score model module i used SQL Transformation with following query</p>
  
  <pre><code>select [Scored Labels] from t1;
  
  update t1
  set [Scored Labels] = '0'
  where [Scored Labels] &lt; '0' ;
  </code></pre>
  
  <p>it works in SQL Server Management Studio but not in azure machine learning. i did not get error and it gave input as output without changing anything. </p>
  
  <p>is there any error? how do i replace negative values with zero?</p>