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 - 2001-01-25 : 12:01:40
|
M David writes "I'm rather new to MSSQL/TSQL....so this coule be an easy one...but....
I've got numerous tables with really dirty data...names, addresses, etc. I've looked high and low for some free procs to change the case on names and addresses to be 'Proper' (for ease of printing) and to fix nasty address string issues like DR=Drive, LN=Lane, Blvd=Boulevard, NW=Northwest, etc...
Am I just too newbie and there is something easy and preBuilt into the environment? Or are these problems that everyone just deals with and tries to prevent with client side validation??
Thanks to All!
M David" |
|
|
|
|
|
Data Cleansing / Sentance Case