Proper Case A String Or Name

SQL 2005 user defined function to convert a string to proper case (title case).Flexible handling of delimiters and apostrophes to cater for words like "hasn't" and also names like "O'Reilly" and "d'Angelo".Mac and Mc surnames are handled generically, with some rules and exceptions which may need to be extended.  Since McIntyre and Mcintyre are both […]

5 (2)

2007-03-14 (first published: )

937 reads

Blogs

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

Read the latest Blogs

Forums

[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F

By yrstruly

I am trying to get data from myslq into mssql with ssis. I am...

xp_cmdshell

By ramyours2003

how to check which job or  stored procedure using xp_cmdshell in sql server ?

consolidate error logs

By ramyours2003

i need to configure job to consolidate sql error log sizes   from multiple servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers