SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?

As a regular reader, you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.

SQL SERVER - MySQL - PostgreSQL - How to Concat Strings? concathuman

Earlier with SQL Server

Earlier I used to use ‘+’ (Plus) operator when I was concatenating strings. Here is the script for the same:

Solarwinds
SELECT 'FirstName' + ' Last Name' AS FullName;

Now with SQL Server

SELECT CONCAT('FirstName',' Last Name') AS FullName;

SQL SERVER - MySQL - PostgreSQL - How to Concat Strings? concatsqlserver

The reason I use the CONCAT function instead of ‘+’ (Plus) operator is because CONCAT functions work in MySQL as well. Here is the example how the same scripts work in MySQL without changing any code.

SQL SERVER - MySQL - PostgreSQL - How to Concat Strings? concatmysql

Additionally, the same code we can use with Postgres as well. Here is the example how the same scripts work in PostgreSQL without changing any code.

SQL SERVER - MySQL - PostgreSQL - How to Concat Strings? concatpostgres

Here is a question to you, does the same code works with Oracle? If you know the answer, I request you to leave a comment here. I am very confident that the same code works with many other databases as well, if you know the name of the same, please leave a note.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , ,
Previous Post
Developer – 10 Phrases Developer Use Too Often
Next Post
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

Related Posts

3 Comments. Leave new

Leave a Reply

Menu