Today, I was cleaning data for upload in the live database. I found few discrepancies in customer names. The names did not have a standard pattern, some of them in proper case, while few others in small / upper case and also some in sentence case. However, the client wanted these names to be converted … Continue reading SQL SERVER – Proper Case User-Defined Function