2015-06-15
charindex(,+ltrim(id)+,,,+@Id+,)>0create 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