title: convert a column in SQLView result to date and filter by a user specified date
body: <p>can anyone help, i have a sql view with a Date column which is a varchar. When i run my statement below i get a conversion error</p>
  
  <p>The [Planned Date/Time] column has some null values in the table so I have written a view like this</p>
  
  <pre><code> select * from vwMDL where [Planned Date/Time] is not null and
                    Convert(date,[Planned Date/Time]) = '04/03/2015' 
  </code></pre>
  
  <p>the above fails with conversion error. Do i select all non null values first and do a further select? If so will it cost me as i have lots of date returning in the view.</p>
  
  <p>Thanks in advance. I am using SQL at the moment.</p>