/* Takes several columns to form a single name */ select concat(prefix,' ',first,' ',last,' ',suffix) as title from names