--如果只要实现楼主的意思:
create table Table1(a varchar(10),b varchar(10))
insert Table1(a,b)
select 'mmm', '11'
union all select 'nnn', '22'
union all select 'uuu' , '33'
declare @sql varchar(100)
set @sql=''
select @sql=@sql+'-'+a from Table1
select right(@sql,len(@sql)-1)
--结果
aa
----------------------------
mmm-nnn-uuu
给你个例子,利用合并函数。(此方法适用于SQL2000版本以上)
create table Table1(id int,name varchar(100))
insert Table1(id,name)
select 1,'a'
union all select 1,'b'
union all select 1,'c'
union all select 2,'d'
union all select 2,'e'
union all select 3,'f'
union all select 3,'g'
create function dbo.fn_b(@a varchar(10))
returns varchar(1000)
as
begin
declare @s varchar(1000)
set @s=''
select @s=@s+name from Table1 where id=@a
return (@s)
end