"Keith Roberts" <anonymous@discussions.microsoft.com> wrote in message
news:00a301c3bc1d$044fd4c0$a101280a@phx.gbl...

>-----Original Message-----
>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@discussions.microsoft.com>
wrote in message
>news:00a301c3bc1d$044fd4c0$a101280a@phx.gbl...
>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 ??
>
>
>
>
>.