Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How can join records into one string

Author  Topic 

roy_kty
Starting Member

29 Posts

Posted - 2006-11-21 : 21:21:53
Dear all,

May I ask how can I join all the records in one column into one strings such as

table a
1
2
3
4

and then the query result is 1234?

Thx for your answer!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-11-21 : 21:23:00
see here http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx


KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-22 : 12:06:52
Note that if you use front end application, you can easily concatenate the data

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -