Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2013-10-28 : 11:27:29
|
| Hi,I would like replace '-' for nothing for example:514-6544562 to 5146544562have some ideas?Thanks |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-10-28 : 11:39:32
|
| [CODE]DECLARE @Temp TABLE (ID int, Name VARCHAR(20))INSERT INTO @Temp VALUES (1, '514-6544562'),(2, '1-2-3-4'),(3, '2345');SELECT ID, REPLACE(Name,'-','') FROM @Temp;[/CODE] |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-10-28 : 15:07:43
|
| Thanks |
|
|
|
|
|
|
replace