ACCESS读取不为空的字段 - MS-SQL Server / 疑难问题

如题.怎么读取数据库中字段不为空的信息?

我想读取数据库中图片一栏不为空的记录


SQL="select * from info where img not isnull"


没有报错.但是它把所有的都读出来了.没有图片的也读出来了..

---

SQL code:
select * from info where img is not isnull

---

SQL code:
select * from info where img is not null

---

SQL code:
SQL="select * from info where img is not isnull"

---

SQL code:
--access不知道行不試下
SQL="select * from info where isnull(img,'')<>''"

---

SQL code:
select * from info where img is not null

---

SQL code:
SQL="select * from info where img is not null"
不好意思，以为楼主差个IS

---

select * from info where img is not null

---

select * from info wher