请问C# access过滤某个字段中包含的字符串

请问C# access过滤某个字段中包含的字符串

例如:
id  u_name  s_id
1    aaa    1,2,3,
2    bbb    2,
3    ccc    3,

现在我想查询里面的不包含"2"这个关键字的记录!

用 select * from mUser where s_id not like '%2%'
结果显示为空!

请问高人指点一下,如果写SQL语句才正确?

---

在线等!期待解决方法!!

---

select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%')

---

应该在不符合记录的条件内筛选
select * from mUser where
s_id not in
(select s_id from mUser where s_id like '%2%')

---

select * from mUser where s_id not like '*2*'

---

ASSCESS跟SQL有些地方不一樣.我也是以前有寫過才知道的.

---

引用

select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%')

执行之后返回是空的!
Access sql查询支持 not in吗?

---

select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%')
可以用了.

原来我在插入数据的时候
s_id字段是文本,在instr的时候应该给个"",要不然这个值是Null,无法对比

而且找到一个更好的语句,谢谢大家的指点.
结帖