December 19, 2001 at 11:18 am
I need to format names, i.e., first names and last names as follows: Change First Character of first and last name to capital letter and take care of special names, such as, Mc Donald, O'Melveny, etc.
Does anyone know of a utility program or script? Please help.
Dagnea
December 19, 2001 at 11:23 am
Are these in the same column or separate? Just makes it easier if they are.
Here's some notes:
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
December 19, 2001 at 11:36 am
They are in separate fields, i.e., First name and Last name are two different fields
December 19, 2001 at 11:46 am
Even easier. look over the article. For special cases, you will need to build a case statement to handle each.
Steve Jones
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy