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 |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2014-08-01 : 14:26:04
|
| I have a table that has over 60 headers. There are some data witin that table that has special charcters mainly (" ") within the columns. how do i remove all quotes within my table, so whereever it has " " it should remove it, example "3245675", "Tetster" should be 3245675 , Tetster etcPlease advise |
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-08-01 : 14:32:32
|
| REPLACE(Col1,'"','') |
 |
|
|
|
|
|
remove special characters from my SQL table