update hz_locations
set address1=REGEXP_REPLACE(address1, '[^0-9A-Za-z/. ()-_]', ' ')
where length(address1) <> lengthb(address1);
No comments:
Post a Comment