db2去除字段值的空格_DB2表数据中存在空格问题解决办法

--创建测试表

create table administrator.testhyg(id int,name varchar(30),birth date);

--插入测试数据

insert into  ADMINISTRATOR.TESTHYG values(1001,'tianjin   ','2017-03-09');

insert into  ADMINISTRATOR.TESTHYG values(1002,'hyg  ','2017-03-08');

insert into  ADMINISTRATOR.TESTHYG values(1003,'dbsec','2017-03-07');

insert into ADMINISTRATOR.TESTHYG VALUES(1004,'   schina',current timestamp);

insert into ADMINISTRATOR.TESTHYG VALUES(1005,'HANG  ZHOU',CURRENT TIMESTAMP);

--查询表数据

select * from testhyg;

select * from testhyg order by name;

----------------------------------------------------------------------------

--用replace函数将数据中的空格替换为*显示出来

select replace(name,' ','*') from testhyg;

select replace(name,' ','*') from testhyg

1

----