title: Trying to convert the date of a column to be mmddyyyy when it is yyyymmdd while in a table with other columns
body: <p>I'm having an issue trying to convert the dates of a column to be a standard MMDDYYYY format.</p>
  
  <p>For example I have a table with data as follows:</p>
  
  <pre><code>ID   |   Date   |   Type   |
  ----------------------------
  1    | 20140308 | License  |
  2    | 20140308 | License  |
  3    | 48       | License  |
  </code></pre>
  
  <p>The outcome I want to receive is:</p>
  
  <pre><code>ID   |   Date      |   Type   |
  -------------------------------
  1    | 3-8-2014    | License  |
  2    | 3-8-2014    | License  |
  3    | 48(not sure)| License  |
  </code></pre>
  
  <p>Is this possible when I have garbage data going into the system? I keep getting an error like this when I try to convert the dates into MMDDYYYY.</p>
  
  <blockquote>
    <p>Msg 241, Level 16, State 1, Line 1 Conversion failed when converting
    date and/or time from character string. Warning: Null value is
    eliminated by an aggregate or other SET operation.</p>
  </blockquote>