On Sun, Oct 26, 2003 at 10:05:07AM -0500, Will French wrote: > > Are there others like me who would like to preserve the empty string > skipping version of CONCAT_WS. Perhaps the new version of the function > could be added under a new name like CONCAT_WS_NOSKIP or perhaps the option > to skip blanks could be provided in an argument. Just curious what people > think.
I agree absolutely. I was thrilled to discover CONCAT_WS and now use it all the time in ways very similar to how you do--joining lists of things that may or may not have values. It would be very irritating to have to rewrite this functionality within MySQL, and tedious to have to do it in the relevant programming language instead. Jesse Sheidlower <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]