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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-08-04 : 15:15:59
|
| Hi,I have a procedure code and part of my coding is this below. I would like to remove anything that says Speaks with a space. All I keep getting is this....(SPEAKS ARABICSPEAKS ENGLISHSPEAKS FRENCH)UPDATE dhs_MonthEndProvidersREVISEDSET [Language] = REPLACE([Language], '%SPEAKS%', ' ')Can you help me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-08-04 : 15:43:15
|
Thank you, that worked! Now what if I wanted to put a comma in where the space was but didn't want the comma to go infront of the first word ex. ,english,italian,chinese,quote:
Originally posted by tkizer
REPLACE([Language], 'SPEAKS', '')Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Procedure Code - Remove