In the following example there is no first name saved in the row "Mozart". The result of concatenation is Null for each statement except those containing CONCAT.