quote:

---

Originally posted by TG

formatting issues are usually handled by the presentation layer. Can you do it there?

If not, Is it always two word values or could there be more than 2 words?
Should the rule be to always capitalize a letter following a space?
Do you have to deal with names like these - which would need rules beyond the space thing:
W.C. Fields
Baron von Trap
Micky O'Brien

check out this topic:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56499

Be One with the Optimizer
TG

---

select upper(left(col1, 1)) +
       stuff(lower(substring(col1, 2, len(col1))), charindex(' ', col1), 1, upper(substring(col1, charindex(' ', col1)+1, 1)))
from   (--This is your table
       select 'PRODUCT GROUP' as col1 union all
       select 'ANOTHER ONE'
       ) as yourTable

output:
Product Group
Another One

quote:

---

Originally posted by mfemenel

Just because I thought this was interesting and since it doesn't have to be dynamic. Having said that I would think you could just do a case statement and be done with the silliness. If you ever got into a situation where this was common I'd look into a CLR function which would be better suited to this type of thing.

declare @testvar varchar(20)='PRODUCT GROUP'

select CHARINDEX(@testvar,' ')
select REPLACE(REPLACE(@testvar,'RODUCT','roduct'),'ROUP','roup')

---