模糊查询的SQL问题

[bigmingming]

notes id
NULL DTHX15020500001
NULL DTHX15020900001
test345 DTHX15021500001
NULL DTHX15021500003
test123 DTHX15021600001
NULL DTHX15032300001
NULL HX15032600005
NULL HX15032600006

想模糊查找NOTEs不等于test123
即
NULL DTHX15020500001
NULL DTHX15020900001
test345 DTHX15021500001
NULL DTHX15021500003
NULL DTHX15032300001
NULL HX15032600005
NULL HX15032600006

[jingxiaoping]

select * from tablename where isnull(NOTEs,'')<>'test123'

[还在加载中灬]

SELECT * FROM TB
WHERE notes IS NULL OR notes<>N'test123'

[Neo_whl]

为什么说是模糊，你要搜的内容比较准确啊，如果要查询notes中不包含test123参考如下：

           select notes,id from 表名
                                                   where notes is null or notes not like '%test123%'

[满天飞雪No1]

with Cra as ( select NULL a ,'DTHX15020900001' b union all select 'test345' ,'DTHX15021500001' union all select NULL ,'DTHX15021500003' union all select 'test123', 'DTHX15021600001' ) select * from Cra where isnull(a,'') not like '%test123%'