>I have a SQL command that returns a single field (phone number), no more than 2-5 records. I would like to string these numbers into a single variable (@PhoneNumbers) using a function. What is the best, most efficient way of doing this? Hopefully using a single select statement…!

See Re: Left joins in one row Message #793544