解决办法有很多: 1.select*from表wheredatalength(字段)=0 2.select*from表wherecast(字段asvarchar(100))='' 3.select*from表where字段like''
1 . select * from 表 where datalength(字段)=0
2. select * from 表 where cast(字段 as varchar(100))=''
3. select * from 表 where 字段 like ''