CONCAT() is what you need! SELECT CONCAT(Firstname,' ',Lastname) AS Name FROM Users;
Terry ----- Original Message ----- > Hi, > > Is it possible to join two fields in a query so that they are displayed > as one column? For exmaple: > > SELECT Firstname + ' ' + Lastname AS 'Name' FROM Users; > > I hope you can see what I am trying to achieve from SQL here! > > Thanks for your help > > _________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
