title: Select distinct values using like
body: <p>not sure if the title really makes the question clear but basically I am using "SELECT DISTINCT" in a combobox to look at distinct log times , however the format of the log tim column (which cannot be changed) is  example :<br>
             AUGUST 29th 9:21pm<br>
             AUGUST 29th 9:22pm </p>
  
  <p>This is no good as even using distinct will judge these as distinct because they are.
  WHAT I WANT : I want an sql statement which will look at the values and select a distinct value based on just the first part e.g AUGUST 29th and not take the time into account.</p>
  
  <p>Anyone got any ideas/code ? </p>
  
  <p>UPDATE ::
  I used ypercube's code and it works however   for the filter I want it so that when I select a date eg 29/08/2013 it then brings the datagrid cursor to the cell where the logtime matches this date , however the logtime must stay in the format "August 29th 9:21pm" , and ideas how to do this in c# ? </p>