A simple google search for "title case sql server" brought this up as its first return
http://www.devx.com/tips/Tip/17608 L. J. Head Software Engineer Remedy Approved Consultant -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Monday, September 25, 2006 12:19 PM To: [email protected] Subject: Re: Question: Title Case Unfortunately I am on SQL 2000 - is there a way in SQL? Thanks. Quoting Chris Williams <[EMAIL PROTECTED]>: > If you are on Oracle, function INITCAP() exists. For example: > > SELECT INITCAP ('JOE SMITH') FROM DUAL > > will return: > > Joe Smith > > HTH > Chris. > >> You could try to do it via OLE in Word if you couldn't find any other >> way >> >> >> L. J. Head >> Software Engineer >> Remedy Approved Consultant >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee >> Sent: Monday, September 25, 2006 11:17 AM >> To: [email protected] >> Subject: Question: Title Case >> >> I apologize if you received this twice, but the system did not send >> the email out. >> >> Is there a command that can convert the text to "title case" - for >> example convert JOE SMITH to Joe Smith? >> >> Thanks. >> >> _____________________________________________________________________ >> _______ >> ___ >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> >> _____________________________________________________________________ >> __________ UNSUBSCRIBE or access ARSlist Archives at >> http://www.wwrug.org >> > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
