晕，刚才的“”与NULL问题没解决，大家继续来讨论

[yan9299]

我的意思是这样的：
写一查询语句，但要TYPE字段的值不等于“”，也不为NULL
我是这样写的
select * from table where type is not null and type is not ""
是错的，大家来指导

[areswang]

select * from table where isnull(type,'')<>""

[-狙击手-]

select   *  
 from   table   
where   type   is   not   null   and   type   is   not   '' 

[一者仁心]

select * from table where type is not null and type != ""

[-狙击手-]

select       *       
from       table       
where       isnull(type,'') <> ''

[sunhonglei2004]

没有看明白楼主的意思

select * from table where type='' and type is not null ??/

[areswang]

不好意思，1楼应是
select * from table where isnull(type,'') <> ''

[utpcb]

select *
from table
where type is not null and type<>''
简单

[kk19840210]

select   *   from   table   where   isnull(type,'')<>''   

[dawugui]

select   *   from   table   where   type   is   not   null   and   type   <> '' 

[kk19840210]

select   *   from   table   where   type   is   not   null   and   type   <> '' 
--可以用到索引

select   *   from   table   where   isnull(type,'')<>''   --使用不到索引

[yan9299]

谢谢大家，问题解决

[kk19840210]

不好意识更正下

select * from table where isnull(type,'')<>''

一样可以用到索引

[zhouchunyu]

select * from table where type is not null and type<>''

这样就不会出错,注意type<>''这个是单引号