Le 13/07/13 00:33, Jean Milot a écrit : Hi Jean,
> I have tried : > > - [NAME] + [FIRSTNAME] , ok but i need an espace > - [NAME] + " " + [FIRSTNAME] , doesn't work > - LTRIM( coalesce( "NAME", '' ) || ' ' || "FIRSTNAME" ) , doesn't work > - "NAME" || ' ' || "FIRSTNAME", doesn't work > - CONCAT( [NAME], [FIRSTNAME] ), doesn't work > > How i can make it ??? Try SELECT "prenom_coach" || ' ' || "nom_coach" FROM "coaches" HSLQLDB is a bit picky about the syntax Alex -- To unsubscribe e-mail to: users+unsubscr...@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