[SQL] How to combine 2 strings together into one new text string with a new name? [closed]

I was trying to add FirstName and LastName together from the Employee table.

CONCAT("FirstName", "LastName")


and I want the result to look the following examples.

I'm expecting to have both FirstName and LastName like this: John Kamara.

Continue reading...