fix institution zips to 5 characters so EPS markets work
update sobsbgi
set sobsbgi_zip = substr(sobsbgi_zip, 1, 5)
where length(sobsbgi_zip) = 10
and sobsbgi_natn_code is null;
fix institution zips to 5 characters so EPS markets work
update sobsbgi
set sobsbgi_zip = substr(sobsbgi_zip, 1, 5)
where length(sobsbgi_zip) = 10
and sobsbgi_natn_code is null;