Hi Regina,
hsqldb can only concat two strings. Some databases allow more params
others not but the standard says only 2 :-)
CONCAT(CONCAT(CONCAT("KdID",' : '),"Vorname"),' ') and so on
Best regards,
Ocke
Regina Henschel wrote:
Hello,
Regina Henschel schrieb:
So I look for a workaround.
Next version
(3)
SELECT CONCAT("KdID",' : ',"Vorname",' ',"Name",' ',"Geburt") AS
"gesamtname", "KdID" FROM "Teilnehmer" "Teilnehmer"
Works with dBase-tables but not with the embedded HSQL. (Rename column
to Geburt because Geburtsdatum is to long for dBase.)
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
