![Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru](http://learnsqlwithbru.com/wp-content/uploads/2011/12/Why_Use_CONCAT1.png)
Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru
![SQL SERVER - Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT - SQL Authority with Pinal Dave SQL SERVER - Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/CONCAT_NULL_YIELDS_NULL1.jpg)
SQL SERVER - Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT - SQL Authority with Pinal Dave
![Pull yourself together: The concatenate operator (||) — A Gentle Introduction to SQL 0.0.1 documentation Pull yourself together: The concatenate operator (||) — A Gentle Introduction to SQL 0.0.1 documentation](https://a-gentle-introduction-to-sql.readthedocs.io/en/latest/_images/concat_city_state.png)
Pull yourself together: The concatenate operator (||) — A Gentle Introduction to SQL 0.0.1 documentation
![concat SQL | concatenate in SQL - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy concat SQL | concatenate in SQL - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy](https://www.wikitechy.com/tutorials/sql/img/sql-images/sql-concat.jpg)