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 |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2003-04-14 : 08:20:46
|
| I have one very messy address table with every combination of capitalization entry imaginable. I need to clean it up so that it can be used for letter headings ext.To start with I thought I would change everything to lower case. Lower (namefield) Lower (add1)Lower (add2) Ext.Now I want to uppercase the first Alpha character of each word in each text field (“word” defined by space after initial word). Any Ideas ?Jim |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-04-14 : 09:04:22
|
| http://vyaskn.tripod.com/code/propercase.txtJay White{0} |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-04-14 : 09:15:40
|
That Does 99 percent of it. They will have to clean up the rest by hand. This will come in handy.Thanks Jay  Jim |
|
|
|
|
|
|
Capitalization Clean up.