Hi Harvey,
>
> I have a backend Mariadb 10 which I access directly using the using the
> MySQL connector.
All right. With MariaDB (and MySQL) the two pipes (||) dont work.
But something like
SELECT CONCAT("Vorname, ' ',IFNULL("Partnervorname",' '),"Nachname") AS
"Name" FROM "Table"
should work.
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
