Try:
select uid from _en_user where loginid='benny'
and CHARINDEX(select NextUser from toc where tocid = '418c742666e44ddfbf8671bf7f43f4fa',uid)
select uid from _en_user where loginid='benny'
and CHARINDEX(select NextUser from toc where tocid = '418c742666e44ddfbf8671bf7f43f4fa',uid)
and CHARINDEX(select NextUser from toc where tocid = '418c742666e44ddfbf8671bf7f43f4fa',uid)>0
a.uid
from
_en_user a,
toc b
where
a.loginid='benny'
and
charindex(''''+a.uid+'''',b.NextUser)>0
NextUser 字段的内容是“'67fe762610904c29abf5273d58857171','9063b078e3314ad1914829f2334ab2ea'”而你要IN 的是“67fe762610904c29abf5273d58857171”,所以应该不会查到可以用LIKE '%67fe762610904c29abf5273d58857171%'本人拙见
insert into #Tn select '''67fe762610904c29abf5273d58857171'',''9063b078e3314ad1914829f2334ab2ea''','418c742666e44ddfbf8671bf7f43f4fa'select * from #Tn
where charindex('67fe762610904c29abf5273d58857171',NextUser)>0