ruilog
Notebook
Blog
About
Content Explore
从字符串中删除不需要的字符[SQL]
Published : 2007-12-21
Categories :
Tech
Tags :
Replace
Translate
SQL
DB2
MySQL
SQL Server
Oracle
PostgreSQL
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', '') str...
1
Categories
All
Other
Private
School
Software
Tech
SmartKit
Marathon
Trip
Relax
Life