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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2011-08-16 : 06:40:55
|
| HiDoes anybody have a function/script which would allow capitalisation of the first letter in each word (when not a number) i.e.I will be receiving data in various formats and want a consistent format to use for possible mailmerge data. The number of words can vary in the field1 SHOE ROAD -> 1 Shoe Roadpotters hosue -> Potters HouseGOLDEN GATE BRIDGE -> Golden Gate BridgeMany thanks! |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-16 : 07:00:44
|
| There are couple of methods discussed in this thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=146068 |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-29 : 07:38:57
|
| why should you do it in DB? do you have presentation layer where you can handle this?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Captilise first letter of each word