title: greater than and less than equals to in sql?
body: <blockquote>
    <p>how can i use greater than equal to and less than equal to instead of using between in SQL</p>
  </blockquote>
  
  <p>I'm checking for date variable in sql</p>
  
  <p>i tried like this.</p>
  
  <pre><code>Date between coalesce(@fromDate,Date) and coalesce(@toDate,Date) 
  </code></pre>
  
  <p>but if user does not enter any of date (fromDate or toDate)</p>
  
  <p>so that I need to convert above condition in <code>greater than equal to and less than equal to</code></p>
  
  <p>please help in syntax in sql.
  thanks</p>