S sjm Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #1 Sql Server 2000数据表1中有个isDel(bit型)，其中的值有1、0和null。若想用Select语句将其中是0和null的记录选出来，应该如何写SQL语句？谢谢！
L lightming Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #2 select * from table where isdel=1?
S shadowpj Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #5 select * from 表 where (isdel=0) or (isdel is null)
D duxing Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #6 select * from 表 where (isdel=0) or (isdel is null) 正确~ where isdel<>1? 貌似不行
湘 湘华仔 Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #7 select * from 表 where (isdel=0) or (isdel is null)
X xuhongxinghome Unregistered / Unconfirmed GUEST, unregistred user! 2008-10-15 #8 select * from 表 where (isnull(isdel,0)=0)
