This is, maybe, a question of taste. I find it useful in the aggregate functions that they ignore all NULLs that come under their purview, but yield NULL if nothing else comes. Now, CONCAT_WS is no aggregate function, but is like them in that it ignores all NULLs that come its way, aside from the first argument, the separator. If all are NULL, it yields empty string. I now find that I wish that in this, too, it were like the aggregate functions, yielding NULL if its arguments are NULL. Comment?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
