SQL中WHERE的NOT用法!

[huayi05]

rs.open "select * from freenews order by id desc where ok<>'0' and ok<>'0-1'",FreeConn,1, 1

这个语句在ASP+SQL中哪儿出了问题呀，如果去掉where ok<>'0' and ok<>'0-1'
又可以读出来，急呀，在线等

[Avoid]

select * from freenews order by id desc where ok!='0' and ok!='0-1'

[hjx398]

这样写就好：
select * from freenews where cast(ok as varchar)!='0' and cast(ok as varchar)!='0-1' order by id desc

[hjx398]

要是存储的数据不是很多的话最好不用text类型

[huayi05]

后面那个!是什么意思来着呢

[huayi05]

如果我在数据库中改成varchar类型，是不是这样写就可以
rs.open "select * from freenews order by id desc where ok<>'0' and ok<>'0-1'",FreeConn,1, 1

[hjx398]

就是不等于的表示符!就是非，那么!=就是非等就是不等的意思了

[huayi05]

如果我在数据库中改成varchar类型，是不是这样写就可以
rs.open "select * from freenews order by id desc where ok<>'0' and ok<>'0-1'",FreeConn,1, 1

[hjx398]

是的

[huayi05]

嗯，结帖了，给分了

[hjx398]

这样写也是不正确的select * from freenews where ok!='0' and ok!='0-1' order by id desc，排序放在条件的后面

[hjx398]

前一个帖子我已经说过了，正确的写法是select * from freenews where ok!='0' and ok!='0-1' order by id desc

[huayi05]

嗯，好的