If all fields were text as above, this was not a problem. But when we changed the above code as follows, we were getting a Conversion error because INT and VARCHAR did not match.<\/p>\n
SELECT 'One' + ',' + 'Two' + ',' + 'Three' + ',' + 12345<\/pre>\nI’ve sampled this with direct literal values in this example, but you know we’ll get the same error when we try to merge data from fields of VARCHAR and INT data types.<\/p>\n
In a practical way, we can use the CONCAT command as follows to merge column values into a single text.<\/p>\n
SELECT CONCAT('One', ',', 'Two', ',', 'Three', ',', 12345)<\/pre>\n
<\/p>\n
Thus, you can combine the String and Int fields with the CONCAT function without considering the type of data.<\/p>\n
CONCAT also handles very well with NULL values. You don’t need to check with ISNULL or something.<\/p>\n
For example, the result returns NULL when you run the following command without using CONCAT.<\/p>\n
SELECT 'One' + ',' + 'Two' + ',' + 'Three' + ',' + NULL + 12345<\/pre>\n
<\/p>\n
However, when using the CONCAT function, the result will return as “One, Two, Three, 12345”.<\/p>\n
SELECT CONCAT('One', ',', 'Two', ',', 'Three', ',',NULL, 12345)<\/pre>\n
<\/p>\n\n
<\/div>\n