Michael ----------Original Message---------
> I am trying to select the firstname and surname fields from a table. > > select firstname + surname fullname from people; > > This does work in other databases but does not seem to work here. > > Am I doing something wrong or is there a different way to achieve this > with mysql? > select CONCAT(TRIM(firstname),' ',surname) AS fullname from people should work Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
