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
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
