Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Proper Case User Defined Function

By Wesley Brown,

This is a little script I wrote before I saw Steve Jones write up on Tame Those Strings Part 7. This is a slightly diffent approach. It will take a string up to 255 chars and case every word first letter upper and the rest of the word lower. This ain't the best way but it was quick and dirty. We use this script to clean up addresses but it should work for names as long as they are not McNeal or some other type of double case words.


select dbo.udf_proper_case() asĀ  from

Total article views: 343 | Views in the last 30 days: 1