title: How to CONCATENATE 2 time datatypes in sqlserver 2008?
body: <p>I'm trying to concatenate two time which is <code>start_time</code> AND <code>end_time</code> and I get this error:<br> <strong>Incorrect syntax near '+'.</strong> What I'm missing? Here is my query</p>
  
  <pre><code>  SELECT schedule.sid AS [ID],
           doctor.dlname + ',' + doctor.dfname + ' ' + doctor.dmname AS [Physician],
           schedule.sday AS [Day],
           start_time + '-' + end_time , &lt;----I get the error here
           doctor.rate AS [Rate] ,schedule.sstatus AS [Status] 
           FROM schedule INNER JOIN doctor ON schedule.did = doctor.did
  </code></pre>