Formatting Data Results...proper case

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" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
news:ePmWA%23lmIHA.4076@TK2MSFTNGP05.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:
> 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
>

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

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

THANKS....excalty what I needed.


"Mike Brind [MVP]" <paxtonend@hotmail.com> wrote in message
news:uIMIS1nmIHA.4292@TK2MSFTNGP04.phx.gbl...
>
> "CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
> news:ePmWA%23lmIHA.4076@TK2MSFTNGP05.phx.gbl... 
>
> http://classicasp.aspfaq.com/genera...se.html

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

"CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
news:eK#UuvunIHA.5368@TK2MSFTNGP04.phx.gbl...
> THANKS....excalty what I needed.
 
http://classicasp.aspfaq.com/genera...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.