字符串问题!!!

[Hegemon]

表A

BM
2100TT12-0016
2103LG11-0215
2103E00-0089


求一SQL语句将'-'去除
结果如下

BM
2100TT120016
2103LG110215
2103E000089

[QKForex]

SELECT REPLACE(BM,'_','')FROM TAB;

[wh62592855]

使用replace()函数把你不需要的字符替换掉就可以了
做个小例子吧 你仿照着就行了

SQL> select name from t1;

NAME
--------------------
21TT-98
33WT-95

SQL> select replace(name,'-') from t1;

REPLACE(NAME,'-')
--------------------
21TT98
33WT95

[gxjwqm]

[Quote=引用 1 楼 huojianfashe 的回复:]
SQL codeSELECTREPLACE(BM,'_','')FROM TAB;
[/Quote]
up

[dawugui]

[Quote=引用 3 楼 gxjwqm 的回复:]
引用 1 楼 huojianfashe 的回复:
SQL codeSELECTREPLACE(BM,'_','')FROM TAB;

up
[/Quote]
一楼错了.

SELECT REPLACE(BM,'-','') FROM A

update A set bm = REPLACE(BM,'-','')

[QKForex]

哦,不是下划线 ,

[tjuxl123]

select replace(name,'-') from t1;