Hello,
J. Schwarz schrieb:
Hi Emil,
Hi,
in a SELECT, I want to concatenate two string columns separated by a string
constant, as in
SELECT column1 + ' <separator> ' + column2
...
I can't get it working, neither by creating predefined SQL-statements or
from OOo basic.
You'd better take:
SELECT "column1" + (' ') + "column2"
If you want to use the query for a data source for a list control, in
HSQL it works better with concat-function:
SELECT CONCAT(CONCAT("column1",' '),"column2")
kind regard
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
