Hi Girvin, > 4. Looking in my MySQL manual, I discovered the CONCAT_WS function, > which is supposed to insert a specified delimiter string between each > field. However, Base objected, stating that it was an unrecognized > field. I tried `,` , `-` and even `|`, but I got the same error no > matter what I used as a delimiter string. > ... > 5. I then tried Drew's suggestion of nested CONCAT functions. This > also does not work. I get a similar failure as in the CONCAT_WS > function. Base complains about the use of ` ` as the first field of > the CONCAT function.
You should use ' (the single quote character), not `: The latter is MySQL's quoting character for identifiers, that is, whatever you enclose in it, will be interpreted (by MySQL as well as Base) as a identifier, in the given context, as a column name. The single quote character, on the other hand, is used to identify a string literal, and this is what you need here. 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]
