I need to concatenate multiple email addresses into one string separated by carriage return and line feed. The table I'm dealing with can have multiple email address records for each parent record. I'm assuming I'll need to loop through the email address table and build the string but I'm not quite sure how to do this in a SQL Scalar-Valued function. Any one have an example you could point me to?

TIA
Jeff