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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-30 : 08:51:31
|
| Rob writes "SELECT profilenm, replace (profiledsc,'_','-') from groupscheddap I need to have this do the above PLUS for all other odd characters in the field. So this will replace _ with - but I also want to replace $ with - ,etc,etc... All ODD characters to replaced with -." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-30 : 08:52:16
|
| I'd give you an answer.... but I've been replaced with a -DamianIta erat quando hic adveni. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-30 : 08:53:11
|
| Actually, it should read:I-d give you an answer---- but I-ve been replaced with a - |
|
|
|
|
|
|
State needed to replace all ODD characters in source