title: Concatenate in sql server query
body: <p>I try to concatenate id and date to populate in dropdown.</p>
  
  <pre><code>select VisitID as Value,  Convert(nvarchar(50),VisitID)+' - '+Convert(nvarchar(50),VisitDate) as Text 
  from Visit
  </code></pre>
  
  <p>above query work for me to concatenate
  but the result is in the form of '21 - Feb 13 2013 12:00AM'</p>
  
  <p>i want the result should be in form of '21 - 02/13/2012'</p>
  
  <p>what I need to do?</p>