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 |
|
js.reddy
Yak Posting Veteran
80 Posts |
 Posted - 2007-10-09 : 08:26:42
|
| I have the following table(example).businessname------------books & stationarycomputers & mobilesfruits & allmale & female each & everI want to replace businessname column as businessname------------books & stationarycomputers & mobilesfruits & allmale & female each & everCan any one help me please!!Thanks and Regards. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-09 : 08:28:37
|
| You want to replace it with what?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
js.reddy
Yak Posting Veteran
80 Posts |
Posted - 2007-10-09 : 08:36:12
|
I have the following table(example).businessname------------books and stationarycomputers and mobilesfruits and allmale and female each and everI want to change businessname column fields(and with &) businessname------------books & stationarycomputers & mobilesfruits & allmale & female each & everCan any one help me please!!Thanks and Regards.quote:
Originally posted by harsh_athalye
You want to replace it with what?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
|
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-09 : 08:47:14
|
| [code]Update TableSet businessname = Replace(businessname, 'and', '&')[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-09 : 08:51:11
|
Update TableSet businessname = Replace(businessname, ' and ', ' & ')Use leading and trailing spaces, or titles like "mandatory" will look ugly...
E 12°55'05.25"N 56°04'39.16" |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-09 : 08:55:00
|
Nice catch Peter!  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
string function