szadroga
asked on
SQL code to create a custom field from SELECT
I have a query that begins with
select table.first_name,
select table.last_name,
...
I want to create a new a field called "Full Name" which will concatentate the first_name and last_name fields. Can this be done using SQL
select table.first_name,
select table.last_name,
...
I want to create a new a field called "Full Name" which will concatentate the first_name and last_name fields. Can this be done using SQL
Select table.first_name & " " & table.last_name From table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect thx