excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no way i would have solved it.

IN

(

SELECT

Item

FROM

dbo.fDelimitedSplit8K(@CompanyID, ',')

)

Thanks again.