create FUNCTION [dbo].[GetString] 

( 

    @Id varchar(100)

) 

RETURNS varchar(1024) 

AS 

BEGIN 

    DECLARE @Str VARCHAR(500)

SELECT @Str=ISNULL(@Str+'，','')+name FROM (SELECT DISTINCT name FROM table where charindex(','+@Id+',',','+cast (id as varchar(20))+',')>0)AS T

    return @Str 

END