title: Concatenate with NULL values in SQL
body: <pre><code>Column1      Column2
  -------      -------
   apple        juice
   water        melon
   banana
   red          berry       
  </code></pre>
  
  <p>I have a table which has two columns. Column1 has a group of words and Column2 also has a group of words. I want to concatenate them with + operator without a space.</p>
  
  <p>For instance: applejuice</p>
  
  <p>The thing is, if there is a null value in the second column, i only want to have the first element as a result.</p>
  
  <p>For instance: banana</p>
  
  <pre><code>Result
  ------
  applejuice
  watermelon
  banana
  redberry
  </code></pre>
  
  <p>However, when i use column1 + column2, it gives a NULL value if Comunm2 is NULL. I want to have "banana" as the result.</p>