这个SQL语句怎么写？？？简单

[zc1972]

如何选取某字段非空的记录集？？
SELECT * FROM xx where hf<>"" ORDER BY sj DESC

除了这个 hf<>"" ,还有什么判断非空的写法？

[shleo]

…………
你怎么又比较是否为''又比较 is not null
只会出现其中的一种情况的

[zc1972]

up~~~~~~~~~~~~~~~~~~~~~~~~~没人明白吗？？？

[Struggling]

try:

Set recordset1 = Server.CreateObject("ADODB.RecordSet")
exec= "SELECT * FROM xx where hf<>'' or hf is not null ORDER BY sj DESC"
recordset1.Open exec,my,1,3

[zc1972]

这个xx是个备注型text16字段，我刚才把它改成varchar，上面语句可以通过。为什么？
还有表中有几个记录的xx字段为""（空）值，但却被当成有值了。。。就是hf<>'' 没有起作用。。。 这又是怎么回事？？？

[hgllucky]

up

[a_zhe_20]

SELECT * FROM xx where hf is not NULL ORDER BY sj DESC

[licrazy5201]

SELECT * FROM xx where hf is null ORDER BY sj DESC

[luluso]

select * from xx where hf not null order by sj desc

[licrazy5201]

看错了，是非空，我写成为空了，不好意思，
SELECT * FROM xx where hf is not null ORDER BY sj DESC

[qwater]

is not null

[Primer2002cn]

结贴吧

[zc1972]

hf<>"" 这样写对不对？？？
是不是还有个 isEmpty 写法？？？
它们联合起来怎么写？这个有错误。。。

SELECT * FROM xx where hf<>"" or hf is not null ORDER BY sj DESC

[shleo]

"SELECT * FROM xx where hf<>'' or hf is not null ORDER BY sj DESC
"
或者"SELECT * FROM xx where hf<>"""" or hf is not null ORDER BY sj DESC
"
有些要用null
"SELECT * FROM xx where hf is not null ORDER BY sj DESC"
选出来的字段比较是否为空为
isnull()

[poolnet]

SELECT * FROM xx where hf<>"" and (hf is not null) ORDER BY sj DESC

[Primer2002cn]

SELECT * FROM xx where (hf<>"") or (hf is not null) ORDER BY sj DESC

[zc1972]

你用的是什么数据库？
SELECT * FROM xx where hf<>"" or hf is not null ORDER BY sj DESC
这个是用在SQL SERVER里的

如果是ACCESS，可以直接用你的那句

isEmpty是VBS的函数。

[zc1972]

为什么我这样写通不过，我是SQL SERVER库。。
sql="SELECT * FROM xx where hf<>'' or hf is not null ORDER BY sj DESC"
而
sql="SELECT * FROM xx where hf is not null ORDER BY sj DESC"
能通过。。。
hf是备注型字段。

[zc1972]

全句是
Set recordset1 = Server.CreateObject("ADODB.RecordSet")
exec= "SELECT * FROM xx where hf<>'' or hf is not null ORDER BY sj DESC"
recordset1.Open exec,my,1,1

============================
但通不过。。。