I'm a total newb in SQL so i have no idea how to concatenate, even if i was given the code, i wouldnt know where to insert the syntax correctly. This query is going to return duplicate records for a unique ID i use (ll.loan_number)... because there are multiple financial packages for each loan number. how do i concatenate this code so it shows the ll.loan_number once, but will show the d.document_value all in a single row? separated by +', '+Use DocNetgoselect ll.loan_number ,d.document_id ,dd.document_name ,d.document_value ,d.create_datefrom [image].link_image_document d with(nolock) inner join loan.loans ll on ll.loan_id = d.loan_id inner join document.documents dd on dd.document_id = d.document_idwhere document_name = 'Financial Package'and d.create_date > '6/16/11'