By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with t as (
select 'Goodyear Tire and Rubber Company' as n
union all
select 'THE HAPPY BEAR' as n
union all
select 'Equifax' as n
union all
select 'MONK HOUSE SALES' as n
union all
select 'Integra Wealth' as n
union all
select 'Ann Taylor' as n
union all
select 'FORUM COMMUNICATIONS' as n
union all
select 'PLOCHMANS' as n
union all
select 'Syntel' as n
union all
select 'Superior Interior Design' as n
)
select
n,
(
select ' ' + (
upper(left(value, 1))
+ lower(substring(value, 2, 999))
)
from (
select value
from string_split(t.n, ' ')
) as sq
for xml path ('')
) as title_cased
from t
| n | title_cased |
|---|---|
| Goodyear Tire and Rubber Company | Goodyear Tire And Rubber Company |
| THE HAPPY BEAR | The Happy Bear |
| Equifax | Equifax |
| MONK HOUSE SALES | Monk House Sales |
| Integra Wealth | Integra Wealth |
| Ann Taylor | Ann Taylor |
| FORUM COMMUNICATIONS | Forum Communications |
| PLOCHMANS | Plochmans |
| Syntel | Syntel |
| Superior Interior Design | Superior Interior Design |