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 |
|
cindylee
Yak Posting Veteran
55 Posts |
 Posted - 2006-06-14 : 20:50:41
|
| Hi gurusI have a customer column where data is in upper caseEX:ACCC CNNN BBC TESTJOHN WAYNEJUSTIN KEMPNow i Just want the starting letter of each word is upper and rest is lowerEx:Accc Cnnn Bbc TestJohn WayneJustin KempAny help much appreciatedThanksC |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-14 : 22:41:43
|
You might try the PROPER() function on this link:http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115I haven't used it, but it claims "PROPER() Returns from a character expression a string capitalized as appropriate for proper names. PROPER similar to the Oracle function INITCAP."The author claims to be a very clever programmer.  CODO ERGO SUM |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-15 : 03:28:41
|
| or If you use Front End application like VB6, you can use vbProperCase functionStrConv(yourString, vbProperCase)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
T-SQL