Question

access查询语句，怎么用空值做为条件查询？

sql="select * from [news] where pha <> "" "

pha为文本类型，但是这个语句查不了，不知道错在哪里。

Answer 1

sql="select * from [news] where pha<>''"
或者
sql="select * from [news] where pha<>"""""

应该是可以的.

Answer 2

select * from tablename where 该房屋是否已售 <> null or 该房屋是否已售 <> ''

Answer 3

sql="select * from [news] where pha <> '' "
这样写

Answer 4

sql="select * from [news] where isnull(pha)"

Answer 5

SELECT * FROM [news] WHERE pha <> ''

SELECT * FROM [news] WHERE NOT pha = ''