title: How to concatenate in SQL Server
body: <p>My database doesn't have a specific column so I created a column in my query by switch. What I need is to concatenate this column with another column in the database:</p>
  
  <pre><code>select 
      certificateDuration ,
     'DurationType' = case
                        when certificateDurationType = 0 then 'Day' 
                        when certificateDurationType = 1 then 'Month'
                        when certificateDurationType = 2 then 'Year'
                      end
  from 
      Scientific_Certification
  </code></pre>