Hi, the easiest would probably be to crate a UDF that will return a comma delimited column with all the phone numbers.

There are 2 ways you can do it, 1...

Alter that column, make it NOT NULL

What is the data type of SiteId in these objects?

dbo.Site_Vw

Adjustments

PurchaseRequest

You can also use a Numbers table to do string manipulations. If you know know about using a Numbers table, look at this link: Using a Numbers table

Here is a...