Apologies -- Newbie Question -- I have a column full of
Surnames that have been entered in Upper case.
I need to change them so that the first letter is
capitalised and the rest of the string is in lower case.

Any Ideas ??

You will have to clean up the existing data using an UPDATE statement, and a
User Defined Function like the following will come in handy:
http://vyaskn.tripod.com/code.htm#propercase
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"Keith Roberts" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Apologies -- Newbie Question -- I have a column full of
Surnames that have been entered in Upper case.
I need to change them so that the first letter is
capitalised and the rest of the string is in lower case.

Any Ideas ??

Narayana -- worked like a dream -- thank you very much --
I shall make sure that I do some shopping in Tescos in
the near future !!!!!

Thanks, hope you enjoy your shopping experience :-)
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"Keith Roberts" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Narayana -- worked like a dream -- thank you very much --
I shall make sure that I do some shopping in Tescos in
the near future !!!!!