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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenating fields by name

Status
Not open for further replies.
nsalinas

nsalinas

Programmer
May 24, 2004
6
US
Is it possible to go from this:

John Smith ProgramID_3
John Smith ProgramID_5

to this?!

John Smith ProgramID_3 ProgramID_5

In other words, just have one name - concatenating the program IDs. I've tried coming up with a solution but have been unsuccessful. Thank you
 
Sort by date Sort by votes
check the FAQ section...there are couple of solutions already provided for this situation...

-DNG
 
Upvote 0 Downvote
Yes, thank you very much!
I did find a solution.
Thread # thread183-967337 was especially helpful!

Thanks Again! :)
~N
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
264
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
382
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
550
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
How to change STRING_AGG to stuff xml to split feature value by pip?
Replies
0
Views
136
ahmedsa2018
ahmedsa2018
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
167
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top