title: How to use the BETWEEN and LIKE operator with two wild card characters
body: <p>I am using the report viewer asp.net 2010 for generating the report...what i want is i am displaying the lost book record between the start-date and end-date. for that in the table adaption configuration wizard.. i am writing the following query... but giving the error...</p>
  
  <p><strong>first try</strong></p>
  
  <pre><code>SELECT book_id, ah_id, ah_name, issue_date, return_date, status, issue_id 
  FROM issue_book
  return_date  BETWEEN ( LIKE CONCAT ('%', @stardate ,'%' ? '%', @enddate ,'%' ))
  </code></pre>
  
  <p><strong>second try</strong></p>
  
  <pre><code>SELECT book_id, ah_id, ah_name, issue_date, return_date, status, issue_id 
  FROM issue_book
  return_date  BETWEEN ( LIKE CONCAT ('%', @stardate ,'%' AND '%', @enddate ,'%' ))
  </code></pre>
  
  <p><strong>third try</strong></p>
  
  <pre><code>SELECT book_id, ah_id, ah_name, issue_date, return_date, status, issue_id 
  FROM issue_book
  return_date  BETWEEN ( LIKE CONCAT ('%', @stardate ,'%' '%', @enddate ,'%' ))
  </code></pre>