重复字符保留1个的问题
如下:程序代码:
create cursor b1 (jnh N(2),m1 c(5),m2 c(5)) insert into b1 values (1,"abcad","abcd") insert into b1 values (2,"adacc","adc") insert into b1 values (3,"abcb","abc") insert into b1 values (4,"aababc","abc")
如何把m1中的重复字符只保留1个,得到结果m2?
谢谢!!!