RE: upper to lower case

RE: upper to lower case

 

  

Of course. Much better.

-----Original Message-----
From: Eric Emrich
[mailto:mssqldba-ezmlmshield-x75935432.[Email address protected]
Sent: Thursday, September 27, 2007 11:18 AM
To: LazyDBA Discussion
Subject: RE: upper to lower case


Select UPPER(left(<my_data>, 1)) + LOWER(right(<my_data>,
len(<my_data>)-1))

Replace the <my_data> with you data or column.

-----Original Message-----
From: Chris
[mailto:mssqldba-ezmlmshield-x63545825.[Email address protected]
Sent: Thursday, September 27, 2007 2:12 PM
To: LazyDBA Discussion
Subject: 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



---------------------------------------------------------------------
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 and any attachments may be confidential or privileged and are for the exclusive use of the intended recipient. If you are not the addressee or intended recipient, please do not read, copy, use, or disclose this communication to others. If you have received this in error, please notify the sender by replying to this message, and then delete it entirely from your system. Delivery of this message and any attachments to any person other than the intended recipient(s) is not intended in any way to waive confidentiality or a privilege. All personal messages express views only of the sender, which are not to be attributed to Finish Line and/or any of its subsidiaries or affiliates, and may not be copied or distributed without this statement.



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