>Supposing I am getting an output of a query. If the
>company name in the database is :
>
>THE GOOD COMPANY INC
>
>How do I convert it to:
>The Good Company Inc
>
>Appreciate
>AB
I don't suppose you're using an Oracle DB, are you? That's as simple as
"SELECT INITCAP(foo) FROM bar"...
Other than that, I believe you have to lowercase the entire string, then
loop through it and cap the first letter after each space...
HTH....
Brandon Whitaker
[EMAIL PROTECTED]
-------
"It'll get used by the same people using Opera. People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
