title: SQL equivalent of Math.Floor() in c#
body: <p>I just want to convert <code>10.111</code> to 10 based on some condition in the following Query</p>
  
  <pre><code>Select 
      case when 2=1 then
          CONVERT(decimal(10,3), 10.111)
      else
          CONVERT(decimal(10,0), 10.111)
      end
  </code></pre>
  
  <p>But it return 10.000
  How can i get 10?</p>