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
