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 -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
