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 |
|
qutesanju
Posting Yak Master
193 Posts |
 Posted - 2009-08-05 : 10:17:52
|
| In my table T1 there are some values like......Meterial Description ------------------------------------------MUFFLER,EXHAUST, G 1" ISO MALE THREADANCHOR,END, TERMINAL STRIP END ANCHORI want to replace ,(comma) by -(dash)how can I do it? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-08-05 : 10:31:55
|
| select replace([Meterial Description], ',', '-')from <yourTable>Be One with the OptimizerTG |
 |
|
|
|
|
|
string related question