Transact SQL Other Articles Software Reviews
Using the Transact SQL Concatenate Function
To concatenate strings together in Transact SQL, you simply need to use the "+" operator:
SELECT 'hello' + ' ' + 'world' AS 'result'
The resulting SQL results set shows hello world as the concatenated string in the result column.
MySQL and Oracle both have a Concat() function, but there isn't one in Microsoft's SQL Server. The MySQL Concat() function for concatenating strings can be used as follows:
SELECT CONCAT('hello', 'world')
Also in MySQL, strings can also be concatenated by simply putting them next to each other in a SELECT query, e.g.
SELECT 'hel' 'lo' ' ' 'world'
Often when concatenating strings with non-string data types in SQL Server it's essential to use the Convert function to convert the non-string data type into a string such as a char or varchar data type. The example below converts the current year from the date into a string:
SELECT 'this year is ' + CONVERT(CHAR(4), YEAR(GETDATE()))