proper or title case function?

I know there are flaws with this type of function (lots of exceptions to
handle such as when "John Jones III" becomes "John Jones Iii" or "Detroit,
MI" becomes "Detroit, Mi") and some of you might yell at me for wanting to
do this type of formatting on the backend, but I was wondering if there is a
proper or title case type of function. Of course there's UPPER and LOWER but
I can't find a PROPER or TITLE. If you don't know what I mean, it's where
the first letter of every word is in upper case and the reset of the letters
are in lower case (MS Word calls it "Title Case"). Just wondering.
Thanks,
KeithKeith,
You're right this is probably better for the middle-tier or client however
see:
http://www.aspfaq.com/show.asp?id=2299
HTH
Jerry
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:e7TnenN2FHA.1100@.TK2MSFTNGP15.phx.gbl...
>I know there are flaws with this type of function (lots of exceptions to
> handle such as when "John Jones III" becomes "John Jones Iii" or "Detroit,
> MI" becomes "Detroit, Mi") and some of you might yell at me for wanting to
> do this type of formatting on the backend, but I was wondering if there is
> a
> proper or title case type of function. Of course there's UPPER and LOWER
> but
> I can't find a PROPER or TITLE. If you don't know what I mean, it's where
> the first letter of every word is in upper case and the reset of the
> letters
> are in lower case (MS Word calls it "Title Case"). Just wondering.
> Thanks,
> Keith
>

proper case for name in sql server

hi,
a field with all capital letters for last name and frist name -- DAVID
JONES
I need a funcation taht I could retrive it from sql query analyzer
select propercase(field1) from names. it returns "David Jones"
THnaksHi
A google search would turn up many hits such as
http://vyaskn.tripod.com/code/propercase.txt but it doesn't cater for all
names e.g MacNeil, McNeil, O'Neill etc..
John
"mecn" wrote:
> hi,
> a field with all capital letters for last name and frist name -- DAVID
> JONES
> I need a funcation taht I could retrive it from sql query analyzer
> select propercase(field1) from names. it returns "David Jones"
> THnaks
>
>