How to concat entries in a text field

[JobaBett]

Hi out there

I would like to have a query concat the strings in one text field from all records in a table.

I'm looking for something like

SELECT SUMTEXT(textfieldName,';') FROM tableName;

to get "textvalue1;textvalue2;textvalue3" etc.

Any help appreciated. Simon

 

[r937]

use GROUP_CONCAT

although to be honest i don't know how many 65K fields you can actually concatenate

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[JobaBett]

Hi r937.

Works like a charm!! Thanks!

Although, to concat numbers, i had to first convert them to char using

CONVERT(somefield,CHAR).

Thanks again! Great Forum!