Qry - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Qry

Author

Topic

avmreddy17
Posting Yak Master

180 Posts

Posted - 2007-05-09 : 16:15:49

Can any one help me writing the Qry to convert the Clientname column to have the Proper Case.

Ex
JAG TRADING LLC ( it should be Jag Trading LLC )
BTN PARTNERS LLC ( it should be Btn Partners LLC ) ..etc

ClientName
--------------------------------------------------
JAG TRADING LLC
BTN PARTNERS LLC
CDC North America
CITADEL
PERRY PARTNERS
PERRY PARTNERS
CLOVIS CAPITAL BULK SETTLEMENT ACCT
JLF Asset Management LLC
DAVENPORT PARTNERS, LP (RAMIUS)

Thanks for any help

cvraghu
Posting Yak Master

187 Posts

Posted - 2007-05-09 : 16:23:17

See this -

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-09 : 16:23:25

There's lots of them all over the net if you can google.

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources