ASP:这句SQl语句怎样错误了

FirstImageName<>''
注意，用单引号。

FirstImageName<>'' or FirstImageName<>null
注意，用单引号。

SQl="select * from news where FirstImageName<>"" order by id desc
这上面你写成了数字类型表示
文本类型为：
SQl="select * from news where FirstImageName<>'' order by id desc

楼主，语句没错，不过注意一下引号的使用，双引号里面只能用单引号了。
SQl="select * from news where FirstImageName<>'' order by id desc"
注意一下，你的表里面一定要有FirstImageName这个字段咯

select * from news where FirstImageName<>"" order by id desc
改成
select * from news where FirstImageName is not null order by id desc
或
select * from news where FirstImageName !='' order by id desc