Hello, the mysql-documentation says, that CONCAT or CONCAT_WS is not a function to use with GROUP BY, but I tried this in version 3.22 and it worked. Why doesn't it work with the latest version? Example: SELECT * FROM bids; +----+-----------+---------+ | id | comment | project | +----+-----------+---------+ | 1 | hello | 3 | | 2 | world | 3 | +----+-----------+---------+ SELECT CONCAT_WS(' ', comment) FROM bids GROUP BY project; +-------------------------+ | concat_ws(' ', comment) | +-------------------------+ | hello world | +-------------------------+ Greetings, Thomas --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php