Jean
The Concat() function would be Concat(Name, ' ', Firstname) the column
names are not in brackets in standard SQL. This will work with
MySQL/MariaDB - I am copying it out a book.
For the second line [NAME] + " " + [FIRSTNAME] try [NAME] + ' ' +
[FIRSTNAME] often ' are used to denote a string not ".
On Fri, 12 Jul 2013 18:33:31 -0400, Jean Milot <jmi...@dotriver.eu> wrote:
Hello,
I have a mdb file and i want to use it with LibreOffice so I need to
"translate" all the macro, form ... for LibreOffice.
But i have some difficult to do it.
For example, how to concatenate 2 field in my SQL Request.
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 ???
Thanks for your help.
If someone could help me to "translate" the file, it would be nice
Sincerely,
Jean Milot
--
Jay Lozier
jsloz...@gmail.com
--
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