title: using LIKE and BETWEEN in sql query
body: <pre><code>alter PROCEDURE [dbo].[select_User_attendance_master_Date]        
  (        
  @From_date NVarchar(100),  
  @To_date NVarchar(100)            
  
  )        
  as        
   begin        
    select           
  
   Employee_Attendace_Code,        
   Convert(varchar(11),Employee_Attendance.Attendance_day,106) as Attendanceday  
  
      from Employee_Attendance        
  (Convert(varchar(11),Employee_Attendance.Attendance_day,106) between '%'+@From_date+'%'    
   AND  '%'+@To_date+'%')     
  
  end
  </code></pre>
  
  <p>this query is not working it is getting nothing in Attendance_day values are eg 2013-11-28</p>