I'll have to give this "Red Stripe" a try.
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x92438281.[Email address protected]
Sent: Thursday, September 27, 2007 11:14 AM
To: LazyDBA Discussion
Subject: RE: upper to lower case
The "proper case" of beer is Red Stripe! Hehe.
It's Fridayyyyyyyy! Partyyyyyyyyy! 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: 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
---------------------------------------------------------------------
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