Le 13/07/13 00:33, Jean Milot a écrit :
> How i can make it ???
>
Alternatively, this will also work :
SELECT CONCAT("prenom_coach" || ' ' || "nom_coach") FROM "coaches"
Alex
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-he
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