解决办法有很多：

1.select*from表wheredatalength(字段)=0

2.select*from表wherecast(字段asvarchar(100))=''

3.select*from表where字段like''