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

Eugene Niemand
Oct 20, 2010 · 1 min read

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

Eugene Niemand’s Blog

Technology and Programming professional and enthusist

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store