Formatting Data Results...proper case

[CD]

I have a asp page pulling results from an Access DB. I have no control of
the data input to the db. All the information is entered in Upper case. It
contains fields like address, city, etc..

DB data:
AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue

Is there a way to format the data on the webpage in proper case with a
fucntion or routine? I am not a programmer by trade but can follow logic.

TIA
CD

[CD]

Re: Formatting Data Results...prope r case

THANKS....excal ty what I needed.


"Mike Brind [MVP]" <paxtonend@hotm ail.comwrote in message
news:uIMIS1nmIH A.4292@TK2MSFTN GP04.phx.gbl...

>
"CD" <mcdye1@hotmail .REMOVETHIS.com wrote in message
news:ePmWA%23lm IHA.4076@TK2MSF TNGP05.phx.gbl. ..

>>I have a asp page pulling results from an Access DB. I have no control of
>>the data input to the db. All the information is entered in Upper case.
>>It contains fields like address, city, etc..
>>
>DB data:
>AddressColum n: 123 BILL AVENUE format to 123 Bill Avenue
>>
>Is there a way to format the data on the webpage in proper case with a
>fucntion or routine? I am not a programmer by trade but can follow
>logic.
>>
>TIA
>CD
>>

>

http://classicasp.aspfaq.com/general/how-do-i-convert-a-name-to-proper-case.html

>
--
Mike Brind
Microsoft MVP - ASP/ASP.NET
>

[McKirahan]

Re: Formatting Data Results...prope r case

"CD" <mcdye1@hotmail .REMOVETHIS.com wrote in message
news:eK#UuvunIH A.5368@TK2MSFTN GP04.phx.gbl...

THANKS....excal ty what I needed.

http://classicasp.aspfaq.com/general...to-proper-case.
html

"there is no universal way ... to handle proper casing correctly, 100% of
the time."

For example, DuPont, O'Leary, von Furstenburg, et.al.