concatenate strings from different records

[dave796]

Hi im wondering if there is a way to concatenate a set of strings when field1 is the same hopefully with a comma seperating each part. E.G

Field1 Field2
abc 122qq
def 456ww
abc 789rt
ghi 999zt
def 873gh

EQUALS
Field1 Field2
abc 122qq, 789rt
def 456ww, 873gh
ghi 999zt

 

[DotNetGnat]

what database are you using...in SQL Server we can use COALESCE function to do this...

-DNG

 

[r937]

DNG, surely there's more to it than just a COALESCE

in MySQL, you can use the GROUP_CONCAT function

r937.com | rudy.ca

 

[dave796]

ok thanks I didn't find out about the COALESCE function managed to use the GROUP_CONCAT function. Thanks for the help