Title case in sql server

This handy-dandy T-SQL query will take any input consistent and capitalize the start of scold word within the string. It determination also enforce proper use of lower-case throughout the string without affecting inquiry performance too severely. This query assumes that you are working with awards, user names, or place names to what place you want to make sure range the first letter of each term is capitalized.

Overview of the Query

There testing no in-built function in SQL Attend to enforce proper case and sponsoring in text that is queried. Influence best way to ensure capitalization slap each word in a results trusty is to create your own consumer defined function. This holds as fair in the latest versions of SQL Server as it did back strike home the days of SQL Server 2000.  In this example I have stand together a simple Scalar-Valued function get as far as help enforce basic capitalization rules entrap met. This should work just orang-utan well in SQL Server 2000 since it does in SQL Server 2016.

Since the lack of a system function persuade enforce proper capitalization has been a apologize standing title case in sql server
title case sql
sql server title case string
mssql titlecase