I have a column called County, and in this column sometimes there is a county and other times its either empty or contains NULL. So far I am able to change it when there is an empty string to N/A, but not sure how to change it if there is a NULL as well.
So far I am using a case statement to check if the column contains an empty string
case County when '' then 'N/A' end
case when County = '' or County is null then 'N/A' else County end