change empty string into null values

PHOTO EMBED

Tue Mar 08 2022 08:13:34 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select *
from location_csv as lc 
where lastname = ''

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