string concatentation in sql

hey /prog/

is there any sort of function in sql like sum() but for concatentating strings instead of adding up numbers?

none of these motherfuckers understand anything as complicated as proper relational databases

go back to fucking about with php + mysql you losers