On Sat, 2017-09-16 at 18:37 +0200, Harvey Nimmo wrote: > 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
Hi Robert, ....but as I now have discovered, the COALESCE command is the correct solution to cope with several alternative syntax combinations by concatenation. Each CONCAT expression in the COALESCE parameter list can represent one of the desired syntax combinations, always assuming that the successive expressions in the parameter list can 'disqualify' themselves by returning a NULL from CONCAT before reaching the desired combination. It strikes me as being quite an elegant solution. Many thanks for your help. 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
