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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-09-01 : 11:10:17
|
| I am looking for a way to seach though column of a table and replace all commas with semi colons. Is there a command that allows for soemthing like this. Thanks |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-01 : 11:13:13
|
| For one column only?UPDATE table SET column = REPLACE(column, ',', ';')Raymond |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-09-01 : 11:30:05
|
| AWESOME! Thanks dude. |
|
|
|
|
|
|
search and replace