SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sean Cooperman / Function to return proper case / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:52:59 GMT20RE: Function to return proper casehttp://www.sqlservercentral.com/Forums/Topic661103-1493-1.aspxGood Idea! A useful improvement would be to incorporate a list of exceptions. For example articles, short prepositions, etc. that are not to be capitalized unless they are the first word.Fri, 20 Mar 2009 14:55:36 GMTegreenawaldRE: Function to return proper casehttp://www.sqlservercentral.com/Forums/Topic661103-1493-1.aspx[font="Verdana"]Thank you very much for the function, sir, you've saved me an hour or two this morning! Many Thanks, Seán.[/font]Fri, 20 Mar 2009 02:17:37 GMTSean RedmondFunction to return proper casehttp://www.sqlservercentral.com/Forums/Topic661103-1493-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/String+Manipulation/65940/">Function to return proper case</A>[/B]Fri, 20 Feb 2009 01:19:39 GMTCoop-546061