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 |
|
bilencekic
Posting Yak Master
121 Posts |
 Posted - 2005-12-28 : 16:59:21
|
| I have an email table and there is FirstName LastName Emailcolons.But i there are records likejoe black joe@joe.comand there are many records with lower chars and same records.Now. i have to delete same records and make the first char of values bigger likeJoe Black joe@joe.comHow can i do this?MS BLESS US |
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2005-12-28 : 17:06:06
|
| But when deleting same recors1 record will reamin for the deleted record.for ex if there is 5 records for joe@joe.com 4 of it will be deleted.i can check one by one. there are 10.000 emails on the table.MS BLESS US |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2005-12-28 : 17:32:35
|
| thx i solved that problem.other problem is converting joe black to Joe Black :(MS BLESS US |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-12-28 : 17:50:53
|
| You can use the UPPER function along with SUBSTRING. Check SQL Server Books Online for details on these two character functions.Tara Kizeraka tduggan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-29 : 01:09:53
|
| Where do you want to show the Init Capitalised names?If you use Front End application like VB make use of Substring with ProperCase functionsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Deleting same records and upper case of first char