On Sat, 2017-09-16 at 18:31 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually > > return a NULL due to the '' (i.e. not a space, zero length)? > > NULL: There is nothing inside, no string, no number, no data ... > Empty: Could only be for strings - nothing to see, but its a string > with > zero length. > > Base will save for default all fields without content as NULL, not as > fields, which are empty. The difference: You could concatenate empty > fields with content of other fields without problems, because it > recognizes an empty string. With NULL it won't work. > > The Help in LibreOffice and the GUI is missleading here, because Base > won't save fields as empty fields but as NULL. > > Regards > > Robert >
Thanks, Robert. I had a feeling that would be the answer. Many thanks for helping me to clear that up. Your proposed syntax is certainly more economical than the COALESCE alternative. Cheers Harvey -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
