紧急求助~~~~~~~~~~~！

[chenshicss]

请问一下各位高手！
T-SQL里怎么去掉记录中有'NULL'的数据啊！
或者怎么查询记录中没有'NULL'的数据啊

[--小F--]

select * from tb where col is null

[SQL77]

select * from tb where ISNULL(COL,'')=''

[dawugui]

[Quote=引用楼主 chenshicss 的回复:]
请问一下各位高手！
T-SQL里怎么去掉记录中有'NULL'的数据啊！
或者怎么查询记录中没有'NULL'的数据啊
[/Quote]
--字段为null
select * from tb where col is null
select * from tb where col is not null

--字符串里面含有'null'
select * from tb where charindex('null' , col) > 0

select * from tb where col like '%null%'

[heruoyong]

SELECT * FROM TableName WHERE col IS NOT NULL

[永生天地]

is null
is not null