sql charindex sql string
6/15/2015 5:12:57 PM
charindex(','+ltrim(id)+',',','+@Id+',')>0
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