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: arslist@ARSLIST.ORG
> 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
