sql合并列 解决办法

朋友项目中有需要先组合2列的值,

select t.PROJECT_ID,'第'+t.期数+'期'+'-'+cast(t.支付比例 as nvarchar(50))+'%' as CC
from dbo.YW_tdzbpm_djksq t
where t.project_id='ZBPM-2011-000013'

然后需要按条件合同列的值，

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[fun_Retrun](@id NVARCHAR(50))
RETURNS varchar(8000)
AS
BEGIN
    DECLARE @r varchar(8000)
    SET @r = ''
    SELECT @r = @r + ',' + ('第'+期数+'期'+'-'+cast(支付比例 as nvarchar(50))+'%')
    FROM YW_tdzbpm_djksq
    WHERE PROJECT_ID=@id
    --PRINT STUFF(@r, 1, 1, '')
    RETURN STUFF(@r, 1, 1, '')
END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO