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 |
|
Amethystium
Aged Yak Warrior
701 Posts |
 Posted - 2003-12-16 : 08:57:43
|
| Greetings,Consider the following string :'AMETHYSTIUM NAZIANO ODONATA ADOLOFO'what I am after is :'Amethystium Naziano Odonata Adolofo'Basically, keep the letter of each word as upper case and convert the rest to lower.I know it's an easy solution for one string but what you have more or less?'Amethystium Naziano Odonata Adolofo''Amethystium Naziano''Amethystium Naziano Odonata'etc...________________Make love not war! |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
|
|
|
|
|
Mixed case names