Hi Harvey, > Hi Robert, > Thanks for answering. > Your suggestion, however, do not work on my Opensuse Leap 42.3 / > LibreOffice 5.3.3.2 configuration. > > I use the Query design feature to enter > > "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" > or > > "Nachname" || IFNULL( ', ' || "Vorname", ' ') > > Both above return 0 (yes, zero!) for every record. > Only the "Partnervorname" field has NULL values. I didn't expect > concatenation to be treated like 'multiplication', but I learn > something new every day! Neverthless, something is not right here. > > However, > COALESCE ( CONCAT( "Vorname", SUBSTR( ' & ', 1 ), "Partnervorname", > SPACE( 1 ), "Nachname" ), CONCAT( "Vorname", SPACE( 1 ), "Nachname" ) ) > > delivers the required result.
Which database do you use? Internal HSQLDB? My system here: OpenSUSE 42.2, LO 5.4.1.2. Have tested all this code for the Base-Handbook, so I am interested why it shouldn't work for you. Must say I didn#t test how it would work when entering the code in GUI mode, not switching to SQL mode. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- 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
