SQL语句查询数字拼接的字符串中的某个数字

类似于一下数据表中的数据：

 

如果想查询其中的某一个ID，如查询71这一项，sql语句如下：

SELECT
 *
  FROM TB_ProjectManagement
  WHERE AttaID like ''%,' +@AttaID+',%'' or AttaID like '''+@AttaID+',%'' or AttaID like ''%,'
  +@AttaID+''' or (AttaID like '''+@AttaID+'%'' and CHARINDEX('''+@AttaID+''',AttaID)=1 and  LEN(AttaID) = LEN('''+@AttaID+''')) AND DelFlag=1

存储过程;

CREATE PROCEDURE [dbo].[SelectProjectByAttaID]
@AttaID nvarchar(10)
AS
BEGIN
declare @sql nvarchar(1000)
 set @sql ='
 SELECT
 *
  FROM TB_ProjectManagement
  WHERE AttaID like ''%,' +@AttaID+',%'' or AttaID like '''+@AttaID+',%'' or AttaID like ''%,'
  +@AttaID+''' or (AttaID like '''+@AttaID+'%'' and CHARINDEX('''+@AttaID+''',AttaID)=1 and  LEN(AttaID) = LEN('''+@AttaID+''')) AND DelFlag=1'
 
 
 -- print (@sql)
 
  exec (@sql)
END