SQL Server: Make all UPPER case to Proper Case/Title Case Here’s a UDF that will do the trick… You will still have to use it to update your data though.