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;
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
__
