SQL> select initcap('abcd') from dual;
INIT
----
Abcd
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x97992116.[Email address protected]
Sent: Thursday, September 27, 2007 11:20 AM
To: LazyDBA Discussion
Subject: RE: upper to lower case
Outstanding! Now, in Oracle, there is a function call initcap that does
this! Hehe. Just a little extra info! Ok? Hehe.
It's Frdiayyyyyyyy! Partyyyyyy! Hehe.
Have a great Day!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Eric Emrich
[mailto:mssqldba-ezmlmshield-x75935432.[Email address protected]
Sent: Thursday, September 27, 2007 2:18 PM
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
---------------------------------------------------------------------
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