SQL Concat and merge values

Question

How to make it correct, whats wrong with this?

SELECT Name, Surname, CONCAT(NAME + ' '+ SURNAME) 'name and surname'
FROM Worker
WHERE Born = '1988';

or

SELECT Name, Surname, 'NAME' + ' '+ 'SURNAME' AS 'name and surname'
FROM Worker
WHERE Born = '1988';

question from:https://stackoverflow.com/questions/65921607/sql-concat-and-merge-values

Answer 1

The standard SQL operator for concatenation is ||, so you want:

SELECT Name, Surname, (NAME || ' ' || SURNAME) as full_name
FROM Worker
WHERE Born = '1988';

Many databases also support a CONCAT() function, although logically you want at least two arguments. SQL Server uses + for string concatenation, but that is not widespread.