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

LOWER

Author

Topic

pazzy11
Posting Yak Master

145 Posts

Posted - 2007-09-28 : 06:34:21

Hi I know i can use a LOWER or UPPER function to change the
case of letters, but say i want to change all but the 1st letter
ie i want MARK SMITH to be Mark Smith ... MARK and SMITH
are 2 seperate columns so im assuming something like

select UPPER(first_name,1) ...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-28 : 06:38:51

E 12°55'05.25"
N 56°04'39.16"

Kristen
Test

22859 Posts

Posted - 2007-09-28 : 06:41:16

And this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Proper%20Case

Sometimes also known as Title Case

Kristen

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-28 : 06:51:13

If you want to show result in Front ends like VB, then make use of StrConv function

StrConv(Rs("column"),vbProperCase)

or

Also refer

http://vyaskn.tripod.com/code/propercase.txt

Madhivanan

Failing to plan is Planning to fail

pazzy11
Posting Yak Master

145 Posts

Posted - 2007-09-28 : 06:56:04

thanks
i came up with :

select ( LEFT(ct_surname,1) + LOWER(RIGHT(ct_surname,(len(ct_surname)-1))) ) from TABLE_NAME

Kristen
Test

22859 Posts

Posted - 2007-09-28 : 07:01:00

What about:

de Someone
O'Reilly
McManus

?

Kristen

pazzy11
Posting Yak Master

145 Posts

Posted - 2007-09-28 : 09:21:24

select ( UPPER(LEFT(ct_surname,1)) + LOWER(RIGHT(ct_surname,(len(ct_surname)-1))) ) from TABLE_NAME