• Nancy, it was just a snippet. here's the whole function:

    CREATE FUNCTION [dbo].[fnConcatUserComplaints] (@UserId int)

    RETURNS varchar(8000)

    AS BEGIN

    DECLARE @strReturn VARCHAR(max)

    SET @strReturn = ''

    SELECT @strReturn = @strReturn+ ComplaintDetail+ char(13)

    FROM ComplaintsTable

    WHERE UserId=@UserId

    RETURN @strReturn

    END