ÇëÇóÒ»¸ösql Óï¾ä

ÓÐÕâÑùµÄ±àÂ룺
倉λ
24C-01-00004
24C-01-00007
24C-01-00010
24C-01-00014
24C-01-00015
24C-01-00020
24C-01-00021
ÎÒÏëÓÃÒ»¸ösql Óï¾ä±ä³É
倉λ
24C0100004
24C0100007
24C0100010
24C0100014
24C0100015
24C0100020
24C0100021

ÈçºÎʵÏÖ£¿

---

replace(倉λ,'-','')

---

ÒýÓÃ

SQL codeselect 倉λ=replace(倉λ,'-',''))from tb--

¶¥¡£¡£¡£¡£¡£

---

SQL code:
select 倉λ=replace(倉λ,'-','')) from tb

---

лл¡£ÎÒÊÔÑé¿´¿´¡£¡£

---

SQL code:

declare @sql nvarchar(50)
set @sql='24C-01-00004'
select replace(@sql,'-','')

24C0100004

---

CREATE TABLE Tb1
(col1  varchar(20))
insert into tb1
select '24C-01-00004'
union
select '24C-01-00007'
union
select '24C-01-00010'
union
select '24C-01-00014 '
union
select '24C-01-00015'
union
select '24C-01-00020'
union
select '24C-01-00021'
update tb1 set col1=