Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining SQL fields in query

Status
Not open for further replies.
yandso

yandso

Programmer
Jul 20, 2001
278
US
I need some help. I am trying to pull first_name and last_name from my database as Name. I have tried using
Code: 
Select first_name+" "+last_name as Name from names
I don't get an error but I also do not get any data. Any help would be great.
 
Sort by date Sort by votes
Assuming you have a table called Names with the fields First_Name & Last_Name, try this...

Code: 
"Select first_name & ' ' & last_name as Name from Names"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
965
leifoet
leifoet
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
573
leifoet
leifoet
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
1K
leifoet
leifoet
Swi
  • Locked
  • Question
PDF Interrogation
Replies
0
Views
361
Swi
Swi
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
563
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top