O'Reilly , SQL Cookbook
by Antbony Molinaro

解决方案：replace(), translate()

DB2
select ename,
     replace(translate(ename, 'aaaa', 'AEIOU'), 'a', '') stripped1,
     sal,
     replace(cast(sal as char(4)), '0', '') stripped2
from emp

MySQL, SQL Server : 不支持 translate()
select ename
     replace(re ...