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"
Greetings
Joern
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
