select *
from location_csv as lc 
where lastname = ''

UPDATE location_csv 
SET lastname = NULLIF(lastname, '')