Actually it worked I had the last line wrong

this is what I have

CREATE function Get_Pop(@pop_group int)

Returns nvarchar(1000)

BEGIN

declare @r nvarchar(1000)

select @r = ''

select @r = rtrim(@r) + type from SM_Servers,SM_group_Link where...

Damn Never mind, i screewed up again!

thank you so much for your help

you saved my ass!

CREATE function Get_Pop(@pop_group int)

Returns nvarchar(100)

BEGIN

declare @r nvarchar(1000)

select @r = ''

select @r = rtrim(@r) + name + "," from SM_Servers,SM_group_Link where (SM_group_Link.group_name = @pop_group) and (SM_servers.ID = SM_Group_Link.group_item)

select substring( @r, 1,...

Doesnt the function have to return a value!

or inlined within another statement will it automatically do that, sort of like the function getdate()?

I tried that and I get this error,

Error 444: select statements within A function cannot return data to a client.

or something like that.

is your example with a UDF or a...