Hello Folks, you might be wondering for a function which would help you to convert your text input into a Title Case (or Proper Case) in SQL Server. Since T-SQL lacks a function to convert text to title case. So, it has to be User Defined.

Therefore, the following will surely accomplish you task:

Now, we will test this function by giving an input:

So, you can see the result below:

1_SQL_Server_User_Defined_Function

Hope you like it :)

 

Regards

Piyush Bajaj

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook