Change Names to Title Case

[Rozza]

Hi I have a table which stores forenames and surnames in seperate columns.

I need to change the font case to Title Case e.g. Paul Rowling as many of the names are stored in upper or lowercase.

How can I do this using an sql statement??

Cheers

Paul

 

[MatthewPeters]

Is that what your looking for?

select upper(left(fName, 1)) + lower(substring(fName, 2, len(fName)-1)) + ' ' +
upper(left(lName, 1)) + lower(substring(lName, 2, len(lName)-1))
from yourTable

Matt

 

[Rozza]

Thanks for your reply. I'll give it a try!!

Cheers

Paul