Erik,

Great! Worked Perfectly

-  Much appreciated, Rick

You are correct, I saw the error last night when I reviewed the report. Your solution works for me!

Thanks!

I worked it out after some coffee and waking up!

What I have to work with was a field called Weekno, it's an int....

This is perfect! - I was really taking the long road with no return.

Thanks again,

Rick

Of course!  can't believe I missed that completely - All is working Great! Thanks so much.

Rick

Just about complete - Now I have a proceeding comma before in the VNDList

The result that I get now after creating the the function.

Type  callcenter       VDNList

1B       Fredericton    ,1034,1534 

Never mind I forgot the dbo. on my select.

Thanks for all your help

R.

Thanks - Sounds good, I created the function 'successfully' I think, now when I run my query

CREATE FUNCTION ConcatVDN (@type varchar(2), @center varchar(25))

RETURNS varchar(4000)

AS

BEGIN

DECLARE @VDNLIST varchar(4000)

SET @VDNLIST = ''

SELECT @VDNLIST...

Declare  @VDNLIST varchar(4000)

SELECT  @VDNLIST = COALESCE(@VDNLIST + ',','' ) + Cast (vdn as varchar(5))

FROM Rpm_Maintenance..vdn_partners AS a

WHERE type = '2b'  and callcenter = 'Fredericton'

select @VDNLIST

This works great, thought...

Thanks Krishnan!

That is much cleaner.

Rick-