INITCAP - 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

SQL Server 2008 Forums

Transact-SQL (2008)

INITCAP

Author

Topic

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2010-11-18 : 02:39:54

CAN ANY ONE HELP ME TO SOLVE THIS:

IN ONE OF THE FIELD EXAMPLE POSITION DESIGNATION AM STORING THE DATA LIKE THIS:

CHIEF EXECUTIVE OFFICER
SOFTWARE ENGINEER
SENIOR SOFTWARE ENGINEER

MY REQUIRED OUTPUT SHOULD BE LIKE THIS ALL THE STARTING LETTERS SHOULD BE IN CAPITALS, AS BELOW:

Chief Executive Officer
Software Enineer

can any one help to solve this senario.

Thanks in advance
kiranmayee

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-18 : 06:04:44

If you use front end application,do this there
Otherwise refer http://beyondrelational.com/blogs/madhivanan/archive/2010/07/19/initcap-function.aspx

Madhivanan

Failing to plan is Planning to fail

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-11-18 : 07:00:58

Refer to this..

http://grownupgeek.com/capslock.jpg

Otherwise you could turn the following into a function:


DECLARE @Jobs VARCHAR(255) 

SET @Jobs = LOWER('CHIEF EXECUTIVE OFFICER') 

WHILE ASCII(SUBSTRING(@Jobs, CHARINDEX(' ', @Jobs)+1, 1)) BETWEEN 97 AND 122 AND CHARINDEX(' ', @Jobs) > 0 
BEGIN 
	SELECT @Jobs = STUFF(@Jobs, CHARINDEX(' ', @Jobs)+1, 1, UPPER(SUBSTRING(@Jobs, CHARINDEX(' ', @Jobs)+1, 1))), @Jobs = STUFF(@Jobs, CHARINDEX(' ', @Jobs), 1, '|') 
END 

SELECT REPLACE(UPPER(LEFT(@Jobs, 1))+SUBSTRING(@Jobs, 2, LEN(@Jobs)), '|', ' ')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources