http://dev.mysql.com/doc/refman/4.1/...functions.html

guarda le funzioni concat e concat_ws.