Solved

SQL code to create a custom field from SELECT

Posted on 2014-09-12
3
127 Views
Last Modified: 2014-09-12
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
0
Comment
Question by:szadroga
  • 2
3 Comments
 
LVL 16

Expert Comment

by:Sheils
ID: 40320147
Select table.first_name & " " & table.last_name From table
0
 
LVL 16

Accepted Solution

by:
Sheils earned 500 total points
ID: 40320149
Sorry missed the field name:

Select table.first_name & " " & table.last_name As Fullname From table
0
 

Author Comment

by:szadroga
ID: 40320157
perfect thx
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now