1.select*from表wheredatalength(字段)=0
2.select*from表wherecast(字段asvarchar(100))=''
3.select*from表where字段like''