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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 camel case

Author  Topic 

sqldev6363
Yak Posting Veteran

54 Posts

Posted - 2009-03-17 : 13:46:04
i have a column name with value 'PRODUCT GROUP'. While i am displaying the result of that coliumn i need to display like this

Product Group

First letter should be capital for PRODUCT and G should be Capital for the word GROUP, Remain should be small

PRODUCT GROUP is one word, there is a space in "PRODUCT GROUP"



dev

pootle_flump

1064 Posts

Posted - 2009-03-17 : 14:49:53
That is called ProperCase not camelCase
http://www.google.co.uk/search?source=ig&hl=en&rlz=&=&q=proper+case+function+%22sql+server%22&btnG=Google+Search&meta=lr%3D
Loads of functions available - first hit is SQLTeam's very own Jeff Smith.
Go to Top of Page
   

- Advertisement -