I want to delete observations that have missing data for a particular variable but stata does not recognize the empty cells as missing when I use the command:

drop if fishing_site==" "

so, I thought it might be a problem with spaces so I tried trimming them but it did not make any changes and still not recognizing missings.

What do I need to do?