In message <4A09A9E8.8090705@xxxxxxxxxxx>, jan <os2@xxxxxxxxxxx> writes >Pete escribió: >> >Try with this mysql function: > >http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group- >concat I didn't think that would work without a group. But I just tried it, and it does! Well spotted. SELECT GROUP_CONCAT(xField) FROM mytable; -- Pete Clark Got any spare time? Anything you need? Barter in Spain Join for free at http://BarterWithBart.com