Hi,
create table #temp (ID INT)
INSERT INTO #temp(ID) VALUES (1)
create table #tempTable (ID INT,Menus VARCHAR(10))
INSERT INTO #tempTable(ID,Menus) VALUES (1001,'1'),(1002,'1,2'),(1003,'2,3'),(1004,'1,4'),(1005,'11,4')
select * from #tempTable where (Menus) LIKE (SELECT CONVERT(VARCHAR(20),ID) FROM #temp)
drop table #temp,#tempTable
I need result like
1001
1002
1004