Re: [libreoffice-users] Base query - CONCAT function

On Fri, 2017-09-15 at 22:46 +0200, Robert Großkopf wrote:
> 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

Hi Robert,
 you are right it works with CONCAT, but, isn't CONCAT inconsistent
here?

This seems to work as desired:

CONCAT( [Vorname], IFNULL( CONCAT( ' & ', [Partnervorname] ), '' ), '
', [Nachname] )

But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually
return a NULL due to the '' (i.e. not a space, zero length)?

Cheers
Harvey



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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