title: MSSQL query returns no results
body: <p>the query:</p>
  
  <pre><code>SELECT sv_inquiry.inquiry_id, sv_inquiry.owner_rep, sv_inquiry.status
        ,sv_inquiry.owner_rep, sv_inquiry.closed_dt 
  FROM sv_inquiry 
  WHERE sv_inquiry.typ = 'incident' 
       AND sv_inquiry.status = 'resolved' 
       AND sv_inquiry.owner_grp = 'service center NL &amp; INT' 
       AND sv_inquiry.closed_dt LIKE '%17-6-2013%' 
  ORDER BY sv_inquiry.inquiry_id DESC
  </code></pre>
  
  <p>the problem:</p>
  
  <p>This query returns an empty resultset unless I leave out "<code>AND sv_inquiry.closed_dt LIKE '%17-6-2013%'</code>", but if I leave that out I get all the results from the last couple of years and I only need to have the results from a specific date.</p>
  
  <p><code>sv_inquiry.closed_dt is a field of the DATETIME type</code>.</p>
  
  <p>I should probably implement the use of CAST or CONVERT, although I don't know how to adjust the query to include that and only show results of a specific date.</p>
  
  <p>(the query is used on PHP site with <code>SQLSRV_QUERY</code> statement)</p>
  
  <p>Can anyone adjust the query for me so I can search a specific date with the <code>sv_inquiry.closed_dt</code> field?</p>