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 |
|
ddobbertin
Yak Posting Veteran
51 Posts |
 Posted - 2006-02-06 : 09:41:08
|
| I have a query that pulls employee names from a db but the names are stored without any kind of checking for capitalization.Ex.last first mLAST FIRST Mlast First mI would like to be able to display all of them as:First M LastAny help would be appreciated. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-06 : 09:44:16
|
| If possible, use your presentation layer to Init-capitalise the words and rearrange themMadhivananFailing to plan is Planning to fail |
 |
|
|
ddobbertin
Yak Posting Veteran
51 Posts |
Posted - 2006-02-06 : 10:12:03
|
| Sorry pretty new to this...I understand presentation layer in networking but not SQL...could you elaborate? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-06 : 10:14:07
|
| I mean the Front End applications like VB6, ASP,.NET, etc.MadhivananFailing to plan is Planning to fail |
|
|
|
ddobbertin
Yak Posting Veteran
51 Posts |
Posted - 2006-02-07 : 13:48:30
|
| Thanks....I figured it I appreciate the help. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-08 : 03:20:00
|
quote:
Originally posted by ddobbertin
Thanks....I figured it I appreciate the help.
Did you do this in Front End Application?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Capitalize letters of records, rearrange