Is it possible to write a statement that selects a column from a table and converts the results to a string?
Ideally I would want to have comma separated values.
For example, say that the SELECT statement looks something like
| 1 |
| 3 |
| 5 |
| 9 |
You can do it like this:
declare @results varchar(500) select @results = coalesce(@results + ',', '') + convert(varchar(12),col) from t order by col select @results as results | RESULTS | ----------- | 1,3,5,9 |