--variable example
declare @x varchar(50)
set @x = 'FEDERATED STATES OF MICRONESIA'

select @x as x,
    replace((select case when N = 1 or substring(@x, N-1, 1) = ' '
                 then upper(substring(@x, N, 1))
                 else lower(substring(@x, N, 1)) end
            from dbo.Tally b
            where b.N <= len(@x)
            for xml path(''))
            , '#x20;', ' ') as CamelCase

--table select example
declare @t table (x varchar(50) not null)

insert @t
          select 'FEDERATED STATES OF MICRONESIA'
union all select 'another ONE'
union all select 'YeT aNoThEr OnE'

select x,
    replace((select case when N = 1 or substring(a.x, N-1, 1) = ' '
                 then upper(substring(a.x, N, 1))
                 else lower(substring(a.x, N, 1)) end
            from dbo.Tally b
            where b.N <= len(a.x)
            for xml path(''))
            , '#x20;', ' ') as CamelCase
from @t a

--table update example
update a set x =
    replace((select case when N = 1 or substring(a.x, N-1, 1) = ' '
                 then upper(substring(a.x, N, 1))
                 else lower(substring(a.x, N, 1)) end
            from dbo.Tally b
            where b.N <= len(a.x)
            for xml path(''))
            , '#x20;', ' ')
from @t a

select * from @t

quote:

---

Originally posted by kamii47

--

Kamran Shahid
Sr. Software Engineer(MCSD.Net,MCPD.net)
www.netprosys.com

---