Frank Schönheit - Sun Microsystems Germany wrote:
Hi John,
Now I got
around the limits by using a view and CONCAT(), but CONCAT can only take
two input items and I need three (field1 + space + field2). Is there
any way around that.
nest them:
CONCAT( CONCAT( ..., ... ), ... )
Ciao
Frank
Thanks. I tried that at first before sending off the e-mail and the
HSQL engine screamed at me. Switched out the space to be enclosed in
single quotations and it worked fine.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
