碎碎念

Q: 如何使用SQL指令搜尋 NULL和空白欄位

A: 

 

Select *
From Table
Where (col is null or col = '')

 

Or

 

Select *
From Table
Where IsNull(col, '') = ''

 

--

轉自 https://stackoverflow.com/questions/15663207/how-to-use-null-or-empty-string-in-sql