Select * FROM Contacts
WHERE particularfield = null
WHERE particularfield = ''
WHERE particularfield = ""
WHERE length(particularfield) = 0
WHERE LEN(particularfield) = 0