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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MS Sql Server LazyDBA home page