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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2005-02-22 : 17:24:59
|
| I have a table something like this.Monkey One TigerMonkeyOneLion......I would like to create a script that dynamically pulls records, which have a space between words and update them to the one without a space. So, the output should look like:MonkeyOne TigerMonkeyOneLion.. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-22 : 17:42:14
|
| select replace(col,' ','')rockmoose |
 |
|
|
|
|
|
Cleaning records