It's either col equals null meaning a field with no value or you've got an epmty string you can use

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

or IsNull method to find epty strngs and null values _______________________________________________________________________________________________ Alec programming[^] expert