vitruvius

16 hours ago, Ingolme said:

The + operator in SQL only does mathematical additions. To concatenate words, use the CONCAT () function. 

Thanks, good to know. But how come the following code works as expected:

SELECT City + ' ' + Country AS Address FROM Customers;

Hi,

I am trying to learn basics of the SQL and following the tutorials on w3schools. Yesterday I was reading SQL Aliases and "Trying it myself". The following code returns 10 rows, each of them being zero. Am I missing something?

SELECT FirstName + ' ' + LastName AS Name FROM Employees;

Thanks.