SQL SERVER — UDF — Function to Convert Text String to Title Case — Proper Case (via Journey to SQL Authority with Pinal Dave)

Really very useful! Copy, Paste, Execute and Use. Saved me a lot of time.

Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source. Run Following T-SQL statement in query analyzer: SELECT dbo.udf_TitleCase(‘This function will convert this string to title case!’) The output will be displayed in Results pan as follows: This Function Will Convert This String To Title Case! T-SQL code of the function is: CREA … Read More

via Journey to SQL Authority with Pinal Dave