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
 SQL Server Development (2000)
 Concatenating strings in an aggregate

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-06 : 20:32:58
Daniel writes "Hi!

I have a problem with string concatenation. Lets say I have the following table:

...
STRING
PROPERTY
...

and I would like to return one string (preferrably delimited in some way) that contains all the strings with a certain property. If the string would have been an integer it'd easily been solved by an aggregate function (sum, avg and so on), but what can you do with strings?"
   

- Advertisement -