RE: upper to lower case

RE: upper to lower case

 

  

select proper('abcdefghi')

Msg 195, Level 15, State 10, Line 1
'proper' is not a recognized built-in function name.

select
upper(left('abcdefghi',1)) +
lower(substring('abcdefghi',2,len('abcdefghi')-1))

---------
Abcdefghi

(1 row(s) affected)


-----Original Message-----
From: Rick Romack
[mailto:mssqldba-ezmlmshield-x54065245.[Email address protected]
Sent: Thursday, September 27, 2007 11:05 AM
To: LazyDBA Discussion
Subject: RE: upper to lower case



Try Proper()


Rick Romack


-----Original Message-----
From: Jim Hill
[mailto:mssqldba-ezmlmshield-x9721487.[Email address protected]
Sent: Thursday, September 27, 2007 10:55 AM
To: LazyDBA Discussion
Subject: upper to lower case

Is there a function which converts data within columns from all caps to
lower with first letter caps??



FIRST -> First

SECOND -> Second





Thanks

Jim


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date:
9/27/2007 11:06 AM



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message from State Compensation Insurance Fund and all attachments transmitted with it may be privileged or confidential and protected from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying, or taking any action based on it is strictly prohibited and may have legal consequences. If you have received this e-mail in error, please notify the sender by reply e-mail and destroy the original message and all copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


MS Sql Server LazyDBA home page