Chaning Case from Caps to Title case

[TheWebDataGuy]

I have got a large SQL Server DB containing applicant names. These names were imported from another DB and they are all in Caps (Capital Letters) but I need to convert them into Title Case (first letter capital rest small) so that I can use them in mail merge.

Any ideas??

Thanks

 

[rac2]

If the names are stored in separate columns for first, middle, and last name -

SELECT STUFF( LOWER(last_name), 1, 1, UPPER(SUBSTRING(last_name, 1, 1)))