Translations:Faq/Base/117/10/en

    From The Document Foundation Wiki

    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. CONCAT prevents null fields being included