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

Re: Formatting Data Results...proper case

"CD" 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
>

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

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

Re: Formatting Data Results...proper case

THANKS....excalty what I needed.


"Mike Brind [MVP]" wrote in message
news:uIMIS1nmIHA.4292@TK2MSFTNGP04.phx.gbl...
>
> "CD" 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
>>
>
> http://classicasp.aspfaq.com/general/how-do-i-convert-a-name -to-proper-case.html
>
> --
> Mike Brind
> Microsoft MVP - ASP/ASP.NET
>

Re: Formatting Data Results...proper case

"CD" wrote in message
news:eK#UuvunIHA.5368@TK2MSFTNGP04.phx.gbl...
> THANKS....excalty what I needed.

> >
http://classicasp.aspfaq.com/general/how-do-i-convert-a-name -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.