create table tb(a varchar(10),b int)
insert into tb select 'a' , 1234
union all select 'a' ,3214
union all select 'a' , 3334
union all select 'b' , 4332
union all select 'b' , 3432
union all select 'b' , 4321
go
create function dbo.fc_str(@a varchar(10))
returns varchar(100)
as
begin
declare @sql varchar(1000)
set @sql=''
select @sql=@sql+' '+cast(b as varchar) from tb where a=@a
return stuff(@sql,1,1,'')
end
go