How do I concatenate strings with SQL?

  Much unlike their string-to-date conversion differences, SQL Server and MySQL use a function for concatenating strings - concat() - which is identical in syntax and performance on both platforms.   As you'll see above, the odd ones out this time round are PostgreSQL and Vertica. Although concat() is also available in Vertica, it can only join … Continue reading How do I concatenate strings with SQL?