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

Multiple records one column separated by comma (,)

Status
Not open for further replies.
visopenlive

visopenlive

Programmer
Jul 1, 2010
19
US
Hai all

I am working on something like this. Hope someone can help me.
Consider this as sample data

Field1 Field2
John GA
Mark FL
Steve MI
John CA
John IL

Can someone assist me on a query to have data like this?

Field1 Field2
John GA, CA, IL
Mark FL
Steve MI

Thanks a lot..
 
Sort by date Sort by votes
What kind of database are you using? Microsoft, Oracle..?? There might be easy solutions depending on the database you are using.

Nitin
 
Upvote 0 Downvote
Yes, I encounter this problem.
Handled it two ways:
1. Importing through MS Access to DBMS
2. Changing the column deliminator to something else, like |
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
560
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
364
mmiah1982
mmiah1982
sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
511
2009luca
2009luca
BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
410
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
379
carp
carp

Part and Inventory Search

Sponsor

Back
Top