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 |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2005-07-01 : 10:01:49
|
Hi all, I know in only a matter of weeks my company are going to ask me to change the characters in the database for many of the tables from upper to lower case...Was just wondering if anyone could give me a heads up on the best way of tackling this... temporary tables and a whole lot of t-sql?Thanks  when life hands you lemons, ask for tequila and salt  |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-01 : 10:04:43
|
| All of the characters? UPPER()?Just the first characters?Are you using a case sensitive collation?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
|
|
|
case conversion