Remove a trailing ® from sql table
update IER_CERTIFICATIONS_HH set CERTIFICATION = SUBSTR(certification,0,length(certification)-1) where CERTIFICATION like '%®%';