b1nary0mega
5/9/2014 - 8:42 PM

Remove a trailing ® from sql table

Remove a trailing ® from sql table

update IER_CERTIFICATIONS_HH
set CERTIFICATION = SUBSTR(certification,0,length(certification)-1)
where CERTIFICATION like '%®%';