title: SQL select query for particular date
body: <p>My table looks like below </p>
  
  <pre><code>tbPatientEpisode
  EpisodeIDP    int
  EpisodeNumber varcher
  EpisodeDate   datetime
  </code></pre>
  
  <p>when try with below SQL query </p>
  
  <pre><code>SELECT * FROM tbPatientEpisode
  </code></pre>
  
  <p>it show me results like below image..</p>
  
  <p><img src="https://i.stack.imgur.com/FI6kL.png" alt="Result"></p>
  
  <p>i want data for particular date like 2013-01-22 for this i tried below SQL query</p>
  
  <pre><code>SELECT * FROM tbPatientEpisode where EpisodeDate  like '%2013-01-22%'
  </code></pre>
  
  <p>but it does't return any row. what wrong with my query or is there any proper way to get this kind of result..any help will be appreciate.</p>